change the sheet name

[ram567]

how do i change the sheet name as Accounts

Set xl_sheet_1 = xl_wb.Sheets("Sheet1")

 

[WinblowsME]

   xl_sheet_1.name = "Accounts"

 

[ram567]

thanks! yes the same thing i did it but it is not changing sheet 1 as accounts

 

[SkipVought]

Ram,

That's EXACTLY what you asked for. Please do some reading in Excel VBA Help!

xl_wb.Sheets("Sheet1").Name = "Accounts"
[/code


Skip,
[sub]
[glasses]Did you hear what happened when the OO programmer lost his library?...
[b]He's now living in OBJECT poverty![/b][tongue][/sub]