pivotguy
01-07-2016, 06:02 AM
The VBA code creates multiple files from input file. I would like to dynamically place a VBA code in each output file.
When "input.xlsm" (attached) code executes , it creates (a) Craig Smith.xls (2 tabs - Summary and detail) (b) Kelly Davis.xls (2 Tabs-Summary and detail) . The end product should look like "1Kelly Davis.xlsm" and "1Craig Smith.xlsm" . I place the code under "summary" module in "1Kelly Davis.xlsm" and "1Craig Smith.xlsm" files.
Any suggestion.
When "input.xlsm" (attached) code executes , it creates (a) Craig Smith.xls (2 tabs - Summary and detail) (b) Kelly Davis.xls (2 Tabs-Summary and detail) . The end product should look like "1Kelly Davis.xlsm" and "1Craig Smith.xlsm" . I place the code under "summary" module in "1Kelly Davis.xlsm" and "1Craig Smith.xlsm" files.
Any suggestion.