Constructing a path to open file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks to previous replies I now have the global variable I need to construct
the network path to a user store file.

The variable CommandN has the no. of 1-7 which dictates a users management
area.

I need to use this to construct the network path to use in a workbooks.open
command.

e.g
workbooks.open("Z:/Systemdown/"&CommandN&"/Userfile.xls")

The module won't compile like this.

Can someone show how to write this line correctly.

Regards and Thanks for any assistance.

Francis Brown.
 
Remove the opening and closing parentheses, and put spaces around
your '&' characters. Without the spaces, VBA treats the &
character as a data type specifier, not a concatenation operator.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 

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

Global Variable 4
Problem with file path to sharepoint 0
Writing Data to an External File 3
Softcode Path from File Open dialog 15
Use external file variable in formula 2
Open file from path in cell and open from current file path 0
Help with paths 2
prompt for path to loop through files 5

Back
Top