Constructing a path to open file
 

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.

Constructing a path to open file
 

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


"Francis Brown" wrote in
message
...
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.