Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

change the sheet name

Status
Not open for further replies.
ram567

ram567

Programmer
Dec 28, 2007
123
US
how do i change the sheet name as Accounts

Set xl_sheet_1 = xl_wb.Sheets("Sheet1")
 
Sort by date Sort by votes

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




Ram,

That's EXACTLY what you asked for. Please do some reading in Excel VBA Help!
Code: 
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]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Daemon11
  • Locked
  • Question
The message "No Input field was found in row >" is not clear
Replies
0
Views
209
Daemon11
Daemon11
Cioqueta
  • Locked
  • Question
Attachmate Extra 6.5 - Failed to update the system registry please try using regedit
Replies
6
Views
257
Cioqueta
Cioqueta
Tommeck37
  • Locked
  • Question
Copy data from Attachmate to Excel in a Loop to a single cell in each sheet
4 5 6
Replies
104
Views
1K
SkipVought
S
mcfloater12
  • Locked
  • Question
can i set the memory of the paste function
Replies
2
Views
111
mcfloater12
mcfloater12
techdude80s
  • Locked
  • Question
Change Number of Recent Macros in Tools Menu
Replies
0
Views
71
techdude80s
techdude80s

Part and Inventory Search

Sponsor

Back
Top