4 Replies Latest reply on Jun 20, 2018 8:59 AM by Josh Brady

    Macro will run in the VBA editor, but won't run stand-alone

    Peter Cranshaw

      I'm working on a VBA (.swp) macro to save the drawings in our company in all of the different file formats our various vendors use and save each one a into a combined .ZIP file.  We started small with different macros doing separate tasks and then manually gathering them up into the target .ZIP file.

       

      Right, now I am working on a super macro to combine the functions of the earlier macro and give it a greater degree of intelligence. Currently its over 600 lines of code spread out over 15 different sub-routines.  I doesn't do everything I want it to do yet but it's getting there.

       

      The problem I have is that it runs fine from the "Microsoft Visual Basic for Applications" editor. But when I try to run it standalone from Solidworks using the "Run Macro" button on the macro toolbar from the drop-down menu, nothing happens.

       

      I'm sure the are more than a few ways that this could be happening, but I could use some advise on what to look for.

       

      Thanks,

       

      Pete