Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mapped vs Network drives | Excel Worksheet Functions | |||
Opening read-only files on a network | Excel Discussion (Misc queries) | |||
Network Drives | New Users to Excel | |||
Network Drives | Excel Programming | |||
Network drives | Excel Programming |