ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   .Display (One for Ron De Bruin maybe!!) (https://www.excelbanter.com/excel-programming/397823-display-one-ron-de-bruin-maybe.html)

John

.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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com