ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Macro Fails Accessed Through IE Browser (https://www.excelbanter.com/excel-programming/277751-excel-macro-fails-accessed-through-ie-browser.html)

Edward Robichaud

Excel Macro Fails Accessed Through IE Browser
 
I am having issues with running a macro in Excel through
the Intranet..

I do not know if this is an Excel, VBA, Internet Explorer
or other.
I access an Excel page through I.E 5.5 or higher and run a
macro. The macro will fail or not complete when run inside
a browser. However, the macro program will run
successfully when the file is accessed directly through
Excel.
To make matters worse, there are 300+ users who access
this file (read-only) and some of them actually can run
the macro through the browser, while most cannot.
My code has been check and deemed okay and not the
culprit, I want to know if anyone has any ideas on how
this could happen?

Everyone is running Win2K, Office 2K, security setting
varies on all machines, but most are medium. The file is
on a shared network drive with ready only access for the
users. Most any macro will fail when run through the
browser. Error 1004 is the error message I see. On Error
Resume Next fix as described for Win95 is not an option.
The Macro will run successfully when access directly in
Excel, or from a very few number of users inside the
Browser.



All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com