opening files on network drives via a brouser

  • Thread starter Thread starter Juuljus
  • Start date Start date
J

Juuljus

Hello,

I have a excel file that makes a report out of many other excel files
according to the right parameters. They all are located on a network
drive, in a same folder. It's working when started in the folder
directly, but the main file must got to the intranet and work in a
brouser.
And it's not working there. Can anyone give me some info about that
matter, or should I consult my local admin about the ways our network
works etc.

Br,

Juuljus
 
OK, have tried now endlessly. Can't get to work. It seems that the
macro in the WB opened in the brouser can't find/locate the file he
needs. Gives runtime error "1004",
 
The last message ende, it mus go on like this:

, method "open" of object "workbooks" failed.

The code is: Workbooks.Open
"//server.name.com/1folder/2folder/3folder/file.xls"

Juuljus

Juuljus kirjutas:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Constant as network drive 6
Launching from IE 1
VBA code to copy multiple Excel files from C drive to network driv 1
macro pointing to wrong folder 2
how to preset to a network drive? 3
Excel VBA Save file to Network in Vista and Office 2007 1
change local drive / folder to network folder 3
ChDrive and ChPath to a network drive 4

Back
Top