Posted to microsoft.public.excel.programming

Rob

external usenet poster

Posts: 718

run a macro at a set time

I want to set a macro to run at a given time.

Application.OnTime 'does this in excel, but I can't find a way in outlook.
any help?

Also, I'd like to be able to pass a parameter to the macro, but that doesn't
seem posible. I'd get round this in excel by putting the parameter in a cell
somewhere, but I don't know where to store it in Outlook.

Thanks in advance
Rob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Macro / function text time to 24hr excel time passed midnight fortotaling hr's	Russmaz	Excel Worksheet Functions	2	March 6th 09 04:58 AM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Help with Macro to Convert Date/Time to Time Only	Bill[_26_]	Excel Programming	5	August 25th 04 01:50 PM
excel - macro - automatic initiation of a macro at a pre-specified "system time"	arunjoshi[_3_]	Excel Programming	3	May 1st 04 09:42 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us