Relative path in a macro

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

Guest

I am trying to use the TransferSpreadsheet and OutputTo commands in a macro,
so that the files created are stored on the same path as the database itself.
I do not want to type the entire path, because I want to be able to place the
database in different people's drives, in any directory, and have the
resulting files be created in that same directory.

Can this be accomplished with macros?
 
Use an expression like this as the FileName argument:

=CurrentProject.Path & "\" & "MyFileName.xxx"
 
Back
Top