Find a file and path through network???

[Alpacino]

Hi peeps,

My work uses a network. Is there a way to find a file in a network that uses http//: address so I can use it to open it can get figures from a xls file.

e.g.
The file I am after is in http//:worknetwork/AlanExample.xls

Any ideas

At the moment I have to download the file i want to the same folder then I use.

Workbooks.open(this.workbook.Path & ......Etc

 

[Andrew Poulsom]

Have you tried opening the workbook by typing the URL in the File name box on the Open dialog? If so the macro recorder may give you some code.

 

[Ruddles]

Otherwise you'd probably need to ask your network admins what the UNC path of your Web server's root folder is.

Either way, you may not have sufficient rights to read a file from that folder.

 

[Alpacino]

Andrew how do I do that???

 

[Andrew Poulsom]

Choose File|Open, enter the URL in the File name box and click OK.