OutputTo Action

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

Guest

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
 
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"
 
Back
Top