Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2,069

.Display (One for Ron De Bruin maybe!!)

..Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"

I get an error message "Object Doesn't support this property or method"
Background to this is using Ron's VBA code to mail out avoiding Security.

If i use Windows.Application.ActivateMicrosoftApp (xlMicrosoftMail) then
Outlook becomes the active Window but i also get the Calculator!!!

Any ideas on this please?

Thanks
John

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Q4 Ron de Bruin	Newbie	Excel Programming	4	August 7th 06 09:26 AM
Ron de Bruin (ADO help)	Ron de Bruin	Excel Programming	3	October 21st 05 06:23 AM
For Ron Bruin Please	Steved	Excel Worksheet Functions	6	April 6th 05 02:19 AM
For Ron de Bruin Please	Steved	Excel Worksheet Functions	6	March 16th 05 12:46 AM
for Ron de Bruin	Valeria[_2_]	Excel Programming	1	January 22nd 04 04:42 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us