PC Review


Reply
Thread Tools Rate Thread

Application.OnTime - Macro Cannot Be Found - Internet Explorer

 
 
Cassie
Guest
Posts: n/a
 
      19th May 2010
Hi Everyone,

I have an excel spreadsheet (excel 2003 SP3) that is opened from a link on
the internet. It is set to open in excel, not the browser window.

When it runs the Application.OnTime code, it tries to reopen the excel file
and says some message about "The macro "C\ Documents and
Settings\{name}\Local Settings\Temporary Internet
Files\Content.IE5\O5GMECC5\TEST1[1].xls'!Module1.DoStuff' cannot be found.

The code is.....
Application.OnTime Now + TimeSerial(0, 0, 1), ThisWorkbook.Name &
"!Module1.DoStuff"

When I initially opened the TEST1 file, I enabled the macros and the
"DoStuff" macro is in "Module1". I can run the "DoStuff" macro if I just
"Call" it.

I have found that this also happens with the Application.OnKey and
Application.OnAction methods.

The code will work if TEST1.xls is not opened from the internet or it is
opened with FireFox.

Does anyone have any ideas about how I can get the Application.OnTime to see
the macro?

--
Thanks, Cassie
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.OnTime - Macro Cannot Be Found - Internet Explorer Cassie.S Microsoft Excel Programming 0 19th May 2010 08:17 AM
execute macro; save it and close using Application.OnTime ina Microsoft Excel Programming 2 12th May 2006 05:20 PM
schedule macro - application.OnTime ina Microsoft Excel Programming 2 9th May 2006 04:27 PM
Application.OnTime -- Unable to Pass Macro with Numeric Parameter Butaambala Microsoft Excel Programming 7 7th Jun 2005 10:55 PM
Macro not found when spreadsheet viewed in Internet Explorer? =?Utf-8?B?QmVu?= Microsoft Excel Misc 1 10th Feb 2005 07:31 PM


Features
 

Advertising
 

Newsgroups
 


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