Thank you Ron and Joel for the code to do this.
Sheldon

On May 9, 10:16*am, "Ron de Bruin" wrote:
See alsohttp://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Sheldon Potolsky" wrote in ...
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- Hide quoted text -

- Hide quoted text -