Macro problems

[Maultard]

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

 

[AlCamp]

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!

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

 

[Steve Schapel]

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.

 

[Guest]

THE DATABASE CONNECTION IS WRONG |
YOU FAILED TO ENTER A PASSWORD |
YOUR ACCESS FILE IS CORUPT