TransferSpreadsheet - File Name

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Is there a way to make the File Name a relative reference
instead of absolute. I will be sending out an access
database with an excel workbook that is updated via an
access macro. I hope to avoid explaining to my users how
to change the file name.

Thanks
 
Roy,

Not possible in a macro to the best of my knowledge, but a piece of cake in
VBA code. If not very comfortable with code, converting your macro to code
is a good start.

HTH,
Nikos
 
Relative in terms of what? It's possible in a macro to use, for example, the
path to the database itself as the path to the EXCEL file.

Please provide more info and I'm sure we can suggest a possible solution.
 
Back
Top