By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Access Export in Vista

P: 5
I have an Access Database that i am using to export a query's results into Microsoft Excel. We switched some PC's to Vista and the function does not work on those PC's. It is done using a Macro and is still going to the same version of Excel. The error message is "The file may be open...." it isn't. "If you are using a template...." I am not. "If the file isn't open check disk space....." there is plenty. Any ideas??
Feb 20 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have an Access Database that i am using to export a query's results into Microsoft Excel. We switched some PC's to Vista and the function does not work on those PC's. It is done using a Macro and is still going to the same version of Excel. The error message is "The file may be open...." it isn't. "If you are using a template...." I am not. "If the file isn't open check disk space....." there is plenty. Any ideas??
Are you using OutputTo or TransferSpreadsheet?

You could try renaming the existing file and seeing if the output will now work when no file is found by creating a new file.

Mary
Feb 20 '07 #2

P: 5
Are you using OutputTo or TransferSpreadsheet?

You could try renaming the existing file and seeing if the output will now work when no file is found by creating a new file.

Mary
I am using "output to". I tried with the original file there, not there, etc. It works on another PC that does not have Vista? Thanks for the ideas, any other suggestions?
Feb 21 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I am using "output to". I tried with the original file there, not there, etc. It works on another PC that does not have Vista? Thanks for the ideas, any other suggestions?
The only other thing I can think of is to change the OutputTo macro to a transferSpreadsheet macro and see if that works.

After that I'm afraid we're in Vista bug territory and I don't want to go there.:D

Mary
Feb 21 '07 #4

Post your reply

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