Used to do tech support for Microsoft Excel. Some macro functions are NOT supported when the workbook is opened over the web. Although this may have changed in XP it was a discouraging factor in 2000 and all previous versions. (I quit before office XP came out) List of supported functions in Excel VB while on the web should be listed in the Microsoft Knowledge Base.
HTH Jonathan -----Original Message----- From: TomMallard [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:49 PM To: ActiveServerPages Subject: RE: Excel Macro in IE What are the security settings for the client browser? Bet that's the problem, if they are "high", it'll disable macros. tom mallard seattle -----Original Message----- From: Priya [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 11:08 AM To: ActiveServerPages Subject: Excel Macro in IE Scenario:- We are trying to open Excel reports from IE and the excel reports have macros built in them through VBA code. An error occurs while excel is trying to run some of the macros (for example, cell validations) telling -- macro "http:......" <macro name> not found. But if the excel file is saved to local disk, macro runs fine. Why is the macro failing to run when excel is embedded in IE ? Also, this works well in Netscape with no errors. Any clues ?? Thanks Priya --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
