View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dtown Dawg Dtown Dawg is offline
external usenet poster
 
Posts: 22
Default 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?