File Locations across users/different PCs

T

Telecorder

Trying to resolve how I can code calls for opening different workbooks in a
sub routine if the program will be saved to and used on a different PC. It
works great on my PC but the code directs it to find/open the file in...
"C:\Users\My User Name\Documents\Folder w-File-to-be-opened\File.xls"

How I do I code it to route to the file as saved on the new users' PC?
 
M

mudraker

If the workbook with the macro is saved to the same folder you coul
use

ThisWorkbook.path & "\File.xls

--
mudrake

If my reply has assisted or failed to assist you I welcome you
Feedback.

www.thecodecage.co
 

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

Template location changes from user to user 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Need Help with Macro Security 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word doesn't hold layout across devices 1
File in use by another application or user 2
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Copy range from multiple files in multiple folders to single sheet in master WB 10

Top