By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

OLE - Applications Name

P: 553

how you to know applications name used for doing OLE programming in Access

Word.Application is for Ms word

similary i want to know names for some other applications such as
windows calculator
Event viewer

Also , is it possible to access non-microsoft applications using OLE - i wonder because there might be any other application we might need to access to work with your Access application !

Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,206
Open the help file for the CreateObject function. It explains the uses of the CreateObject function and states what kind of applications are available for it's use. I believe most if not all Office applications support automation as well as several other microsoft applications.

Applications and or programs that do not support automation can be run through the Shell command. I suggest also taking a looking at the help file for the Shell command as conveniently the example for it shows how to open the calculator from Access.

The best way to get to these specific help files is to put your cursor on the word "CreateObject" or "Shell" in the VBA editor window and then press F1. This will bring you directly to that help file.
Aug 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.