PDA

View Full Version : tough one, vba open,save,close a third party app



Adonaioc
11-18-2008, 02:05 PM
I have a application called Cayman, Its used to run manufacturing equipment, I have an excel file that came with the program that allows you you import export and i have tweaked it a little, but i want to be able to save the file once it is cleaned. Im sure there is a way, but I dont know the proper syntax. Does anyone know how this can be done or a way for me to view the other program so that i can see how to accomplish this?

Sub AttachCayman_Click()
'Set m__cayObject = CreateObject("Cayman.Wirelist")
Set m__cayObject = GetObject(, "Cayman.Wirelist")
End Sub


m__cayObject.sListInsertWire
m__cayObject.sListDeleteWire


these are a couple of strings that i was given and or found by a guess in the dark.

If you need more info let me know

Kenneth Hobs
11-18-2008, 02:31 PM
That is a late binding method. Try setting a Reference in Tools so you can use early binding. You may have to browse to find the typelib or dll.

Adonaioc
11-19-2008, 08:14 AM
I found and opened the .tlb file and that listed all the commands i needed Thank you SO much!