Access Export in Vista

[mtexplorer]

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??

[MMcCarthy]

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 TransferSpreads heet?

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

[mtexplorer]

Are you using OutputTo or TransferSpreads heet?

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?

[MMcCarthy]

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 transferSpreads heet 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