Consulting

Results 1 to 3 of 3

Thread: tough one, vba open,save,close a third party app

  1. #1
    VBAX Regular
    Joined
    Mar 2008
    Posts
    78
    Location

    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

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    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.

  3. #3
    VBAX Regular
    Joined
    Mar 2008
    Posts
    78
    Location
    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
  •