PDA

View Full Version : Copy all sheets to new Workbook



tqm1
06-21-2007, 03:06 AM
Dear Experts

How to copy all sheets, including VBA source codes, to new workbook.

Please help

lucas
06-21-2007, 08:42 AM
Why not just copy the workbook?

Pam in TX
06-22-2007, 04:05 AM
Dear Experts

How to copy all sheets, including VBA source codes, to new workbook.

Please help

Couldn't you just "save as" with new file name?

tqm1
06-22-2007, 06:20 AM
Dear Sir,

For some reasons I do not want ot use SAVE AS

I want to copy all sheets into new workbook through VBA Codes

Aussiebear
06-23-2007, 03:13 PM
and these reasons are?