save format & data to new workbook
 

Saving a **workbook** (as a workbook), whether using save or saveas should
preserve all this information. That said, in Saveas, you can specify the
fileformat as the second argument. If you use FileFormat:=xlWorkbookNormal,
then you will save it as a workbook. If you choose xlcsv or some other
format, then that format does not support saving formatting information or
formulas.

--
Regards,
Tom Ogilvy


"La Durande" wrote in message
...
Using a template to produce an invoice I now need to save result as a new
workbook with the Save As facility.
I have found that the save I have produced only saves format & non formula
values.

I require format and values of all field in cells selected