View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheldon Potolsky Sheldon Potolsky is offline
external usenet poster
 
Posts: 15
Default Appending Contents Of Multiple Spreadsheets Into One

Hello. I would like to open up a new spreadsheet and append rows 2 -
EOF from six other spreadsheets into that new one, be prompted for the
name to save it with, then save and quit. Would someone be kind
enough to offer some VBA code to do this with?
Thank you,
Sheldon Potolsky