Morning macronewbie


"macronewbie" wrote in message
...

I want to "save as" the generated new workbook automatically when I click
the command button to create the new wokbook. Is this possible? THANKS!

Not sure if you want to be able to choose a path and filename. This is a
simpler version:

ActiveSheet.SaveAs Filename:="c:\Temp\CSVfile.xls"