MS Excel SaveAs Without Prompt, VBA MS Access
Posted on 2011-09-07
I have the following code at the end of a function that edits an Excel spreadsheet within an Access code, VBA:
apExcel.DisplayAlerts = False
apExcel.DisplayAlerts = True
Supposedly, this should save the file without any prompts. Strangely, it seems to save the file, the prompt again if I want to save the prompt. I recently upgraded from Access and Excel 2000 to 2010, and this code worked fine with those. However, everything I read says this should work.
Anyone have any ideas?