Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Macros: Can you use relative paths??

Status
Not open for further replies.
SlakeB

SlakeB

MIS
Jun 15, 2005
40
US
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.
 
Sort by date Sort by votes
I believe you have to use the full path. You can convert that macro into VBA however; and then use a variable.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
386
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
296
combo
combo
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
394
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
407
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
272
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top