VB program to save to Excel with data in Sheet 1 and Sheet 2

[lldavid]

Hi,


Can you kindly provide me sample VB codes to save a data into one single excel file with data in Sheet 1 and Sheet 2?

All i was able to do is save data in Excel Sheet 1.

Thanks for the big help.

LLD

[appuvmk]

Hi,


Can you kindly provide me sample VB codes to save a data into one single excel file with data in Sheet 1 and Sheet 2?

All i was able to do is save data in Excel Sheet 1.

Thanks for the big help.

LLD

I am not sure what exactly you need. but this is what i understood. you are not able to open a new sheet and save data in it. if you could open sheet 1 similar way open sheet 2( Sheets.Add
ActiveSheet.Nam e = "Sheet name"
ActiveSheet.lots of options u get here )

hope it helps.