View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default .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