Using Excel 2k
I have workbook that contains several worksheets. I need to save some of
those sheets as individual workbooks.
I know I can copy them out as a csv file but I need to save them as xls and
retain the formating.

Is that possible?

Glen

Glen

right click on the sheet you want to make into a new workbook. Select "Move
or Copy ..." from the option list. In the top box, select "(new book)" and
click on "Create a copy". Save the new workbook and/or email it out,
whatever.

Regards

Trevor


"Glen Mettler" wrote in message
...
Using Excel 2k
I have workbook that contains several worksheets. I need to save some of
those sheets as individual workbooks.
I know I can copy them out as a csv file but I need to save them as xls
and
retain the formating.

Is that possible?

Glen

I need to do this programmatically. You put me on the right track. It
works just fine.
Thansk!

Glen

"Trevor Shuttleworth" wrote in message
...
Glen

right click on the sheet you want to make into a new workbook. Select
"Move
or Copy ..." from the option list. In the top box, select "(new book)"
and
click on "Create a copy". Save the new workbook and/or email it out,
whatever.

Regards

Trevor


"Glen Mettler" wrote in message
...
Using Excel 2k
I have workbook that contains several worksheets. I need to save some
of
those sheets as individual workbooks.
I know I can copy them out as a csv file but I need to save them as xls
and
retain the formating.

Is that possible?

Glen