Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default opening files on network drives via a brouser

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default opening files on network drives via a brouser

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",

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default opening files on network drives via a brouser

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:
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", method "open" of object "workbooks" failed.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mapped vs Network drives Greg Excel Worksheet Functions 2 January 12th 10 07:16 PM
Opening read-only files on a network Dryzz Excel Discussion (Misc queries) 1 October 10th 07 10:32 PM
Network Drives Keith New Users to Excel 2 July 6th 06 10:38 PM
Network Drives Nick S[_7_] Excel Programming 2 August 11th 05 04:44 PM
Network drives [email protected] Excel Programming 0 July 17th 03 04:37 AM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"