8 Replies Latest reply on Sep 7, 2018 8:21 AM by Eric Bunn

Control Solidworks to run Solidwork Macro from Excel

Jason Harren Oct 15, 2014 5:02 AM

Is it possible to create a macro in Excel , once I click it , it will : start Solidworks and automatically run the macro stored in "C:\Desktop\Sld" then closes everything leaving the excel worksheet open ?

If so can any kind soul please help ?

Re: Control Solidworks to run Solidwork Macro from Excel

Jason Harren Oct 15, 2014 5:03 AM (in response to Jason Harren)

Deepak Gupta are you able to write an Excel file to do this ? sorry for bothering you again
Like Show 1 Likes(1)

Actions
Re: Control Solidworks to run Solidwork Macro from Excel

Daniel Andersson Oct 15, 2014 7:15 AM (in response to Jason Harren)

It is possible but I got to ask why. There is api function for the document manager which enables you to edit some of the data of the SW files without opening them in SW.

That method is way quicker than loading SW and open the file.
Like Show 2 Likes(2)

Actions
Re: Control Solidworks to run Solidwork Macro from Excel

Deepak Gupta Oct 15, 2014 12:27 PM (in response to Jason Harren)

What purpose you're looking to solve via running the macro from Excel?
Like Show 1 Likes(1)

Actions
- Re: Control Solidworks to run Solidwork Macro from Excel
  
  Jason Harren Oct 15, 2014 10:20 PM (in response to Deepak Gupta)
  
  Deepak Gupta Because I already have another macro that will get the files from a folder and passte them as hyperlink , my purpose is to combine these 2 macros together so that I can , convert the drawings and save into specified folder , and paste them as hyperlink
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Control Solidworks to run Solidwork Macro from Excel
    
    Deepak Gupta Oct 15, 2014 10:50 PM (in response to Jason Harren)
    
    OK, why you need another macro and why not do that in one. Any chance if you can share that macro to look at?
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: Control Solidworks to run Solidwork Macro from Excel
      
      Jason Harren Oct 16, 2014 3:20 AM (in response to Deepak Gupta)
      
      I just need the excel to start solidworks , run the solidworks macro , finish the job , closes Solidworks and call out the excel sub to paste them as hyperlinks .The solidworks macro is the one u wrote for me last time if you remember . Deepak Gupta
      
      Like Show 1 Likes(1)
      
      Actions
Re: Control Solidworks to run Solidwork Macro from Excel

Lohith Na Mar 30, 2018 6:23 AM (in response to Jason Harren)

same requiremnt for my project
Like Show 1 Likes(1)

Actions
- Re: Control Solidworks to run Solidwork Macro from Excel
  
  Eric Bunn Sep 7, 2018 8:21 AM (in response to Lohith Na)
  
  I did it this way using RunMacro2. This is code inside of Excel that runs a Solidworks Macro. This is the only code that resides in Excel. Call out path of macro, module name,macro name. Assign this macro to something in Excel and click it.
  
  Sub RunSWMacro()
  
      Dim swApp As SldWorks.SldWorks
      Dim swModel As SldWorks.ModelDoc2
      Dim RunMacroError As Long
      Dim boolstatus As Boolean
  
      Set swApp = CreateObject("SldWorks.Application")
      Set swModel = swApp.ActiveDoc
  
      boolstatus = swApp.RunMacro2("C:\Users\bunner\OneDrive - Sealed Air Corporation\Computer\Desktop\Active Templates\Fagerdala Windshield Template - Rev 1.3 Not for Distrubution\Windshield Template 1.3.swp" _
      , "modMain", "main", 0, RunMacroError)
  
  End Sub
  
  Like Show 1 Likes(1)
  
  Actions

Go to original post