Access Macros: Can you use relative paths??

[SlakeB]

When performing certain macros like 'transfer to spreadsheet', can you use relative paths (like ../spreadsheets/test.xls) to the files involved or do you need to use the full absolute path (like C:/spreadsheets/test.xls)?

relative paths don't seem to be working for me.

 

[hneal98]

I believe you have to use the full path. You can convert that macro into VBA however; and then use a variable.