I have a macro that copies data from one spreadsheet into a new workbook. At
the end I want to call the Save As dialog for the user to enter a file name
and save straight away.

I know this is probably dead easy, but I just can't get it working.

cdb