help with creating new files

[lylegross]

I wondering if someone could write a code to extract these templates and possibility more in the future: Template MOV , Template SANDBAG, and Template TEMP from the file name test data input BIR.xlsm and place them in there own files such as MOV.xlsm.

I would like to do choose which template to change to a file if possible.

The best I can do is write this macro for extracting the files very

Please Login or Register  to view this content.

Thanks

Lyle

[xladept]

Maybe if you change these lines:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.