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 Chris Miller 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

DarkOne72
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
343
lameid
lameid
BFroeschlKC
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
503
dhookom
dhookom
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
1K
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
380
combo
combo
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
1K
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top