Optimize Current VBA Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-1895192%22%20slang%3D%22en-US%22%3EOptimize%20Current%20VBA%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895192%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%20some%20code%20that%20generates%20scorecards%20and%20places%20one%20in%20one%20network%20folder%20as%20a%20pdf%20and%20the%20other%20on%20a%20different%20network%20folder%20as%20password%20protected.%20Currently%20it%20takes%20a%20little%20over%20two%20hours%20to%20run.%20Is%20there%20a%20way%20I%20can%20speed%20this%20up%3F%20I%20would%20love%20to%20see%20your%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1895192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I have attached some code that generates scorecards and places one in one network folder as a pdf and the other on a different network folder as password protected. Currently it takes a little over two hours to run. Is there a way I can speed this up? I would love to see your suggestions.

0 Replies