View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Hunter[_2_] Ken Hunter[_2_] is offline
external usenet poster
 
Posts: 1
Default runtime error 1004 when opening excel file via VBA in a browser

What version of excel is installed on the webserver is
irrelevant as the file is being opened on the client's pc.
(for the record excel is not even on the webserver).

Let me put the problem another way. If you have a file
called c:\file1.xls with a button that does
workbooks.open "c:\file2.xls". Open IE and drag file1.xls
into the browser - it will not work.

And no - making IE load excel outside the browser is not
an option - it is a locked down desktop.

Ken

-----Original Message-----

Ken,

Make sure the correct version of Excel is installed on

the web server. Also
check out the KB article

Q135390 XL: Sample Macro to Open or Activate a Workbook
http://support.microsoft.com/?id=135390

which has information about similar error arising from

Workbook Open /
activation.

Thanks,

Jim

Jim Vita
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and

confers no rights.

.