setting the path

R

Rob

Hi I am using the following to get my file locations

Set wShell = CreateObject("WScript.Shell")
path = wShell.SpecialFolders("Desktop")
path2 = "E:/Backup"

I need to change path 2 to be the same location as the
mdb file almost like a root.

Is this possible?

Thanks

Rob
 

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
date as filename 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Desctop Shortcut question 0
Automation of scanned file storage based on content 0
Scroll does not show preview 0
OneNote error after installing Windows 10 0
Set Folder path for entire module 3

Top