OutputTo Action

[Frank]

I am using the OutputTo action in one of my macros. I have the Output File
argument hard coded to a folder on my C drive. Is there a way to have that
output file defualt to the current folder without hardcoding the entire path?
Sort of like using the App.path in a visual basic solution.

Thanks for any advice.

Frank

 

[Douglas J. Steele]

If you just put a file name (no folder), it should be written to the current
folder. Problem is, you can never be sure what the current folder is (it's
seldom the same folder where the MDB file exists).

Assuming you're using Access 2000 or newer, try using

CurrentProject.Path & "\MyFile.txt"