Defining paths of files

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have a sheet which has macros to open other files and
fill them out with data.

To open the files, i specify the entire file path. The
folders are currently on a shared drive. i wish to burn
the folders and spreadsheets onto CD's. DO i have to
change the file path within VB , and what happens when one
persons CD drive is volume D: and the next is volume Z: etc

I apprecitae this is probably a simple question prased
badly, but i would appreciate your help.

Regards

Richard
 
Hi Richard

You can use the path of the workbook with the macro's.

In VBA Thisworkbook.path
 
You must log in or register to reply here.

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

Problem with file path to sharepoint 0
Active or current file path 9
Windows 10 Insufficient disk space to fix volume bitmap. 5
File Path 1
Getting/using the File path of a spreadsheet 1
Changing Path of .JPG file? 4
Windows XP Autochk.exe full path help or fix 6
ftp paths defined in variables are persisting. How to clear?(vba) 3

Back
Top