Excel formula is causing Access to prompt a save message

[Dave_D]

The title may sound strange but here's the scenario. Access opens and reads in my Excel file just fine. When EOF, it prompts whether or not to save the excel. The excel is designed with a Worksheet_BEFORECLOSE which performs a final calculation before closing, by computing the average score for those cells which contain a value. This VBA formula also works fine independently. The Excel is also designed with a WORKSHEET_CHANGE. What I feel what is happening, is that either the BEFORECLOSE or CHANGE is occurring when Access is trying to close the file. I have not found a viable solution for this; so right now the VBA formula in Excel is comment out.

[ssanfu]

Sorry, not enough info to give a good response.

Would need to see the dB and the Excel workbook, or post the code for both Access and the Excel events........

[Micron]

Wondering if the standard prompt you get when closing some xl workbooks (with formulae) has anything to do with it. You say the xl code runs fine, presumably when opened manually, so I'd guess that the lack of a delay in Access, which would allow xl to finish before Access attempts the next step, could be the problem. To be honest, I never bothered to master pauses with Do Events since it seems to be less than perfect. If bypassing the problem xl code only when Access is using the file is a possible work around, then you might be able to use a custom trigger in a shortcut command line switch to assign a value to the Command property of a db (I assume this is also possible with a workbook).

This value comes from the shortcut switch only if the shortcut is used to open the db. If it's there, you make code execution go one way, another if not.