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.