Generate an excel report in current directory

[agt119]

Hi all,

I'm generating an excel report from my access application with VBA, using: DoCmd.OutputTo acReport...

I currently place the files in My Documents.

My question is, how can I tell the application to generate the files in the same directory where the aplication's files are located? This means, if my app is at c:\AAA then the files are saved there, if the app is at d:\GGG then the files are generated there.

Is there a way to do that?

Thanks in advance!

 

[PHV]

What about CurrentProject.Path ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[agt119]

as always thanks a lot PHV!!