Using Lookups within VBA Code?

[Whitieklf]

IN VBA I use the following command to navigate to a network drive and open a specific file.

Workbooks.Open Filename:= _
        "\\ Network\Address\Folder\Filename.xlsm", Password:="ABC"

In Cell K3 of Sheet1 I have a formula that fills in the username of the person opening the spreadsheet (this is a unique value).

Is there any way to use this username to open a specific file dependent on who opens it?

IE

\\ Network\Address\Folder\(Contents of Sheet1 K3).xlsm

Hope this makes sense.

Paul

 

[VoG]

Try

Workbooks.Open Filename:= _
        "\\ Network\Address\Folder\" & Sheets("Sheet1").Range("K3").Value & ".xlsm", Password:="ABC"

 

[Whitieklf]

Hiya!

That works perfectly!

Thank you soo much!

Paul