Hi Friends,
I have 100s of Excel workbooks with single sheet in each. Every time I have to open each workbook and run the macro to do the job.
I am looking to modify and run the macro on list of workbooks in folder one by one.
So Macro will run through all excel files in folder one by one and save them and close.
Sample excel macro enabled file attached.
Note: Macro will have copy each row 9998 times. Here in this macro I am getting popup box to enter number of rows.
I have 100s of Excel workbooks with single sheet in each. Every time I have to open each workbook and run the macro to do the job.
I am looking to modify and run the macro on list of workbooks in folder one by one.
So Macro will run through all excel files in folder one by one and save them and close.
Sample excel macro enabled file attached.
Note: Macro will have copy each row 9998 times. Here in this macro I am getting popup box to enter number of rows.
Hightail Spaces
Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.
spaces.hightail.com