Object Properties 1

[stonemonolith]

Hi

I'm new to vbscript. I've seen several vbscripts on the net that open an Excel spreadsheet. I wanted to experiment to see if I could open another spreadsheet application (OpenOffice sCalc)

I finally got it to open using
Dim myObj
set myObj = CreateObject("Wscript.Shell")
myObj.Run """C:\Program Files\OpenOffice.org 2.1\program\sCalc.exe"""

Now I'm trying to add a value to the first cell, using myObj.Cells(A1).Value = ("Fiirst Name"), and I get an error message saying the Object does not support the property 'Cells'

Is there a way I can get a list of the properties that are available?

 

[dm4ever]

The method you opened sCalc is not exactly the same way that the Excel examples you have seen have been accessed. To be honest, I do not know if sCalcs exposes anything that you may be able to use from a vbscript stand point. You may want to check to see of OpenOffice has and SDK you can download that may contain information regarding automating it.

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[dm4ever]

Found this thread that may help.

http://www.oooforum.org/forum/viewtopic.phtml?t=41951&view=next

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid