Set and use application path in Access VB

S

Sunny Okorie

How best can I set and maintain a string for Application
path to be used any where in a VBA for Access?
 
F

FrankFelder

Sunny said:
*How best can I set and maintain a string for Application
path to be used any where in a VBA for Access? *
Click to expand...

Try this one:

CurrentProject.Path will return the application path.

dim spath as string
dim sFile as string
sFile = "somefile.txt"
spath = currentproject.Path & "\" & sFil

FrankFelde
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Outlook 365 - How to access and edit special IMAP folders path? 0
VBA - exporting serial letters to single documents 0
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
Incorporating the User Profile location into a document template path 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Default local file location - folder redirection slowness 0
Office 365 Outlook adding unwanted HTML to Email Body 0

Top