Wiki Home

Automation Objects

Namespace: Wiki
Please add new entries in alphabetical order by application name.

To programmatically invoke the object model of...

AccPac Advantage Corporate: oAccPac=CreateObject('ACCPAC.xapiSession')

AccPac Report Master for Windows: oImpApp=CreateObject("Impromptu.Application.30")

Bar Tender: oBarTender = CreateObject("BarTender.Application")

Crystal Reports: oCRApplication = createobject ("CrystalRuntime.Application")
This doesn't invoke an IDE actually.

EUDORA: oEud = CreateObject("Eudora.EuApplication.1")

FaxMaker: oFax = CREATEOBJECT("fmfaxapi.application")

File System Object oFSO = CREATEOBJECT("Scripting.FileSystemObject") (no IDE)

Group Wise oGroupWise = CreateObject("NovellGroupWareSession")

LotusNotes: oNotes = CreateObject("Notes.NotesSession")
oNotes = CreateObject("Notes.NotesUIWorkspace")
oNotes = CreateObject("Lotus.Notessession") (Domino 5.0.3)

MS Access: oAccess = CreateObject("Access.Application")

MS Common Dialog: oCommmonDialog = CreateObject("MSComDlg.CommonDialog") && !!! You can't directly create this object without a development licence, so for dynamically doing it on another machine, see below. -- Peter Crabtree

MSExcel: oExcel = CreateObject("Excel.Application")

MS Front Page: oFP = CreateObject("FrontPage.Application")

MS Graph: oGraph = CreateObject("MSGraph.Application")

MS Internet Explorer: oIE = CreateObject("InternetExplorer.Application") IEAutomation Example

MS Map Point: oMapPoint = CreateObject("MapPoint.Application")

MSN Messenger: oMessenger = CREATEOBJECT("MSNMessenger.MessengerApp")

MS Net Meeting: oNetMeeting=CREATEOBJECT("")

MS Outlook: oOutlook = CreateObject("Outlook.Application")

MS Outlook Express: None - It is not a COM server!

MS PowerPoint: oPP = CreateObject("PowerPoint.Application")

MS Project: oProj = CreateObject("msProject.Application")

MS Source Safe: oVSS = CreateObject("SourceSafe.0")

MS Word: oWord = CreateObject("Word.Application")

MS Visio: oVisio = CreateObject("Visio.Application")

MS Visual Basic: ?

MS Visual CPlus Plus: oCpp = CreateObject("MSDev.Application")

MS Visual Foxpro: oVFP = CreateObject("VisualFoxPro.Application")

MS Windows Scripting Host: oWSH = CreateObject("WScript.Shell")

Novell Group Wise oGroupWise = CreateObject("NovellGroupWareSession")

PCAnywhere (host): oPCAHost = CreateObject("WinAWSvr.BeHostDataManager")

PCAnywhere (remote): oPCARem = CreateObject("WinAWSvr.RemoteDataManager")

QuickBooks: QBSessionManager = CreateObject("QBFC2.QBSessionManager")

Rational Rose: oRose = CreateObject("Rose.Application")

Snag It: oSnag = CreateObject("SnagIt.ImageCapture.1")

TAPIFax: oTAPIFax = CreateObject('FaxServer.FaxServer')

WindowsShell: oWSH = CreateObject("Shell.Application")

Windows Media Player:
oPlayList = oWmp.PlaylistCollection.GetAll()
oWmp.currentPlaylist = oPlayList.Item(0) && Zero based array
*!* Music starts!

Windows Messenger: oMessenger = CREATEOBJECT("Messenger.MessengerApp")

Win Fax: oWinFax = CreateObject("WinFax.SDKSend")

Win Print : oWinPrint = CreateObject("WinPrint.WinPrintX")

SQL-DMO object: loSQL = CREATEOBJECT("SQLDMO.Application")


Scripting Shell: oShell = CreateObject("WScript.Shell")

Scripting Network Object: oNet = CreateObject("WScript.Network")

Scripting Regular Expression Parser: oReg = CreateObject("VBScript.RegExp")

SQL DMO SQL Server: CreateObject("SQLDMO.SQLServer")

Is just the object enough for most people to get started? I'm wondering if some of these objects might warrant listing a few of the more common and/or tricky commands (e.g. just because I figured out how to get a session object in AccPac doesn't give me a clue as to how to get any data out of the [email protected]#$% thing...).
-- ScottMinar

You can always use an Object Browser, and of course Intellisense does help. -- Alex Feldstein

I'd vote for creating additional new Wiki topics for each expanded item, like Bar Tender above. The best thing to add would be a link to an online Object Model for for each object. I think this topic should stay a single, quick at a glance, view of objects we find ourselves using. -- ?df

Great idea. Especially with something as complex as SQLDMO. -- George Tasker
Not jumbled anymore. -- Christopher Olson
Example of a wrapper for a control that just won't behave (like the MS common dialog control):
DEFINE CLASS oleCommonDialog AS Container
  ADD OBJECT ole AS oleControl WITH OLECLASS = "MSComDlg.CommonDialog"
*(Others can be wrapped like this, but not this one:)
  OLECLASS = "MSComDlg.CommonDialog"

-- Peter Crabtree

What kinds of problems does this solve? - William Fields
See also: Automation Examples
Category C _ O _ M Category Automation Category 3 Star Topics
( Topic last updated: 2004.07.26 02:31:48 PM )