TransferSpreadsheet - File Name

[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

 

[Nikos Yannacopoulos]

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

 

[Ken Snell [MVP]]

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.