-
tough one, vba open,save,close a third party app
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?
[VBA]Sub AttachCayman_Click()
'Set m__cayObject = CreateObject("Cayman.Wirelist")
Set m__cayObject = GetObject(, "Cayman.Wirelist")
End Sub
[/VBA]
[VBA]
m__cayObject.sListInsertWire
m__cayObject.sListDeleteWire
[/VBA]
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
-
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.
-
I found and opened the .tlb file and that listed all the commands i needed Thank you SO much!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules