467,907 Members | 1,440 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

problem exporting to excel via autoexec

7 of 9
Ok here is the situation: I have an Autoexec macro that does the following in order
1) Runs a set of queries(1-9)
2) Exports the final query to excel
3) Does some formatting (subtotals etc)
4) Saves the changes in excel
5) Emails the excel file

The problem is that when it saves the changes in excel (4) the process stops because excel warns that the file already exists. How do I stop this from happening? I know access DoCmd.SetWarnings False / true but that wont stop the warnings in excel
Jul 19 '07 #1
  • viewed: 1382
Share:
1 Reply
MMcCarthy
Expert Mod 8TB
What code are you using to save the changes to excel? OutputTo or TransferSpreadsheet?
Jul 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mustufa Baig | last post: by
1 post views Thread by Mustufa Baig | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.