Creating a new Excel Workbook from existing Workbook.

[nateshk]

Hi All,
I need to create a new excel workbook from an existing workbook keeping the column structure intact as the existing one using a macro.

i open the existing worksheet using Workbook.open command, then i save it using a different name using command workbook.saveas. but in this case the open sheet in which i have written the macro is renamed as the new one.

can anyone help me out ?

Thanx

Natesh

 

[SBendBuckeye]

Hello Natesh,

Check out the SaveCopyAs method. I think it should do what you need.

Good LucK!

 

[nateshk]

hi SBendBuckeye ,

it worked smoothly. thanx a ton. but i have one more concern. when i use savecopyas syntax, it copies the macro code also which i donot want to happen. can u solve this one also.

thanx again

natesh