Macro problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey, I'm trying to run a macro that will enable a table to be exported to
Microsoft Excel. For some un known reason, when i try to run the macro, a
help message appears telling me that i cannot run the macro due to the fact
that the fact that Access cannot find the file that i want it to export to.
Thing is that the file it there!

Am i doing something wrong?? I think that i have put in all the nesserary
parts but it still comes up with the same problem. And yes, I have spelt the
file name correctly!

Please help

Thanks
 
Are you using the OutputTo action??
Since you didn't tell us where the file is (the complete path and
filename), and what you entered in your macro under OutputFile, I can only
guess at a solution.

You wrote...
And yes, I have spelt the file name correctly!
Click to expand...

This leads me to think that perhaps you are just putting the file name
in the OutputTo. Try entering the complete path and filename. (ex.
C:\MyDir1\MyDir2\MyXLSFile.XLS)
hth
Al Camp
 
Maultard,

I agree with Al's suposition about the full path for the export file.

However, I would recommend the TransferSpreadsheet action rather than
OutputTo.
 
THE DATABASE CONNECTION IS WRONG |
YOU FAILED TO ENTER A PASSWORD |
YOUR ACCESS FILE IS CORUPT
 
Back
Top