Access to model from Excel

Discussion in 'SolidWorks' started by fred, Dec 12, 2003.

  1. fred

    fred Guest

    Hi, I am trying to get access to the Sldworks model from Excel. The VBA code
    in Excel that I am using starts

    Dim swApp As Object, Part As Object

    Sub import()
    Set swApp = CreateObject("SldWorks.Application")
    Set Part = swApp.ActiveDoc

    If Part.GetType() = 3 Then 'swDocDRAWING Then
    ...

    This macro works fine on one PC here but not on my PC. We are both running
    XPP, SolidWorks 2004, Excel '97.
    The problem I am having is that the swApp.ActiveDoc always returns "nothing"
    and yet on the other PC it works fine.
    We both have "SldWorks 2004 Type Library" selected in the references in
    Excel.

    Has anyone got any ideas on what is wrong on my PC.

    Thanks
    Fred
     
    fred, Dec 12, 2003
    #1
  2. fred

    Philippe Guglielmetti Guest

    this *may* start a new, invisible SW session.
    Use GetObject(,"SldWorks.Application") instead to connect the running
    session (note the comma...)
     
    Philippe Guglielmetti, Dec 12, 2003
    #2
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. Reading Excel File without starting Excel ?

  2. What Api function to know tie excel of a model .sldprt?

  3. AutoCAD Link with MS-Access/Excel

  4. access table to a sheet of excel?

  5. Retrieved Excel Cell values containing Excel Formulas are returned Empty.

  6. Attribute to excel and excel to attribute?

  7. Using Excel instead of Access as a database

  8. create 2D template (for physical model) from 3D Autocad model

Loading...