How can I copy and save only one sheet of the active workbook.
This method copies the whole workbook and I only need to copy and save one
of the sheets:
ActiveWorkbook.SaveCopyAs
Thank you.
Diana
How can I copy and save only one sheet of the active workbook.
This method copies the whole workbook and I only need to copy and save one
of the sheets:
ActiveWorkbook.SaveCopyAs
Thank you.
Diana
Rock,
Sub save_sheet_to_new_workbook()
'copies it to a new workbook
ThisWorkbook.Worksheets(1).Copy
'the new workbook is now active
ActiveWorkbook.SaveAs "saved copy"
End Sub
hth,
Doug
"Rock*" <[email protected]> wrote in message
news:[email protected]...
> How can I copy and save only one sheet of the active workbook.
>
> This method copies the whole workbook and I only need to copy and save one
> of the sheets:
> ActiveWorkbook.SaveCopyAs
>
> Thank you.
> Diana
Excellent! Doug thank you for your help and time.
--
Diana
"Doug Glancy" wrote:
> Rock,
>
> Sub save_sheet_to_new_workbook()
>
> 'copies it to a new workbook
> ThisWorkbook.Worksheets(1).Copy
> 'the new workbook is now active
> ActiveWorkbook.SaveAs "saved copy"
>
> End Sub
>
> hth,
>
> Doug
>
> "Rock*" <[email protected]> wrote in message
> news:[email protected]...
> > How can I copy and save only one sheet of the active workbook.
> >
> > This method copies the whole workbook and I only need to copy and save one
> > of the sheets:
> > ActiveWorkbook.SaveCopyAs
> >
> > Thank you.
> > Diana
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks