I am currently using the following to open Outlook using VBA:
How can I first check to see if Outlook is already open? (I don't want to open multiple instances)Please Login or Register to view this content.
I am currently using the following to open Outlook using VBA:
How can I first check to see if Outlook is already open? (I don't want to open multiple instances)Please Login or Register to view this content.
Hello djvice,
You can use GetObject to test if an instance of a object has been created.
Note: GetObject will not detect instances of an object created in VBA code. If you start Outlook from VBA then GetObject will always return an error.Please Login or Register to view this content.
Sincerely,
Leith Ross
Have a look at the entry for the GetObject Function in Excel help.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks