SaveCopyAs use always the file type of the parent workbook

I suggest to change this and add a fileformat parameter because it is easy to make a copy of a xlsm as xlsx this way

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Barb Reinhardt" wrote in message
...
I know when we save in Excel 2007, the file type should be defined. It
appears that isn't a requirement for SaveCopyAs. Can someone confirm?

Thanks,
Barb Reinhardt