Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

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
How can I call IE browser (Back button) through Excel macro? SAM SEBAIHI Excel Discussion (Misc queries) 0 December 14th 06 12:49 AM
How can I call IE browser (Back button) through Excel macro? SAM SEBAIHI Excel Discussion (Misc queries) 0 December 13th 06 04:50 AM
Macro Suddenly Fails Bill Martin Excel Discussion (Misc queries) 2 September 16th 05 01:55 PM
Button fails to call macro when open an Excel via Intranet tigertax Excel Discussion (Misc queries) 1 April 12th 05 10:21 AM
Running macro in a browser window Ted Theodoropoulos Excel Programming 1 August 4th 03 08:24 PM


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

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

About Us

"It's about Microsoft Excel"