Macro to copy all spreadsheets into 1 spreadsheet
Hello.
I have a folder that has 300 excel spreadsheets in it. I take these 300
spreadsheets and combine them into 1 spreadsheet buy going to run"cmd"
prompt and then using dos commands to copy all 300 into 1 spreadsheet.
Is there a macro that will do this all for me so I don't have to everytime
go out to "cmd" prompt and type the dos commands?
|