Constructing a path to open file

[Francis Brown]

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.

[Chip Pearson]

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" <FrancisBrown@discussions.microsoft.com> wrote in
message
news:A230323D-6F4A-4705-9E61-D0D1A5460404@microsoft.com...
> 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.