properties and methods of OLE

[questionit]

epots9 ,

i was wondering how would we find out properties and methods of OLE code.

For example, i have a code in VBA that opens a word document and writes some text.

Set oWord = CreateObject("word.application")
 Set oDoc = oWord.Documents.Add()
 'Add text to the document.
 oWord.Selection.TypeText "This is a test.  "
 

This code piece uses two methods .Documents and .TypeText . These 2 i have found from the internet but image using these Word and other applications, you may need 100s of different methods and properties; and in the programming languge you use, you will not find these properties/methods even in the help or library document.

How to get list of these for different applications i.e word, excel, IE, etc

Also, i was wondering how would i open windows Calculator "calc.exe" . I have tried Set oObj = CreateObject("calculator.application") - but this doesn't work.

Thanks#

I think is what OLE is.

[bartonc]

epots9 ,

i was wondering how would we find out properties and methods of OLE code.

For example, i have a code in VBA that opens a word document and writes some text.

Set oWord = CreateObject("word.application")
 Set oDoc = oWord.Documents.Add()
 'Add text to the document.
 oWord.Selection.TypeText "This is a test.  "
 

This code piece uses two methods .Documents and .TypeText . These 2 i have found from the internet but image using these Word and other applications, you may need 100s of different methods and properties; and in the programming languge you use, you will not find these properties/methods even in the help or library document.

How to get list of these for different applications i.e word, excel, IE, etc

Also, i was wondering how would i open windows Calculator "calc.exe" . I have tried Set oObj = CreateObject("calculator.application") - but this doesn't work.

Thanks#

Word Object Model Reference

I don't know if your SDK comes with OLE/COM Object Viewer. In VS2005 it in ...PSDK...|Tools.

[JKing]

Also, i was wondering how would i open windows Calculator "calc.exe" . I have tried Set oObj = CreateObject("calculator.application") - but this doesn't work.

Thanks#

This is straight from the windows help file for the shell command in VBA.

Shell Function Example
This example uses the Shell function to run an application specified by the user. On the MacIntosh, the default drive name is “HD” and portions of the pathname are separated by colons instead of backslashes. Similarly, you would specify Macintosh folders instead of \Windows.

' Specifying 1 as the second argument opens the application in 
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)    ' Run Calculator.
 

Though the path may differ slightly and perhaps be "C:\WINDOWS\SYSTEM32\CALC.EXE"