AnsweredAssumed Answered

Unload VB macro without closing SW

Question asked by Cory McHale on Feb 8, 2013
Latest reply on Oct 28, 2013 by Jeremy Marvin

Currently, I keep my VBA macros on my hard drive and run them from there. I also upload copies to our server when I make changes so everyone else can use them, and also as backup. However, if someone else has run the macro on the server (and not closed SW since) I cannot copy over it, because "it is open in another program." Is there a way to completely close out of the macro without closing SW? I've considered creating a separate macro with the sole purpose of running the useful macros. This would allow me to map all the user macro buttons on the toolbar to one file with different subroutines, and I believe it would completely unload the useful macros from SW when completed. SldWorks::RunMacro2 with Options set to swRunMacroOption_e.swRunMacroUnloadAfterRun. I haven't gone this route yet, because 1) it's not that big of a deal, and 2) I figure there's a better solution.

Outcomes