Renaming Excel sheet with Visual Basic

Dev Shed Forums Sponsor:

March 26th, 2003, 05:50 PM

biaz

Junior Member

Join Date: Jan 2003

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

Renaming Excel sheet with Visual Basic

Hey

How to rename excel sheet from within VBA code (module)?

I need this as I have to export data to access database and no punctuation is allowed. Original names have punctuation.

Thanks

March 26th, 2003, 08:31 PM

Onslaught

/(bb|[^b]{2})/

Join Date: Nov 2001

Location: Somewhere in the great unknown

Posts: 5,163

Time spent in forums: 6 Days 1 h 34 m 20 sec
Reputation Power: 791

Here is a little snippet that will rename all the sheets in the workbook to "sht"#

Code:

    Dim txtCnt As Integer
    Dim i As Integer
    iCnt = Application.Sheets.Count
    For i = 1 To iCnt
        Application.Sheets(i).Name = "sht" & i
    Next

__________________
Joe

How To Ask FAQ | How To Be A Hacker | Hacker Mindset | jQuery

March 27th, 2003, 10:39 PM

biaz

Junior Member

Join Date: Jan 2003

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

I'm glad this snippet worked ...unlike my freshly installed office.

Thank U huge

Last edited by biaz : March 28th, 2003 at 01:28 AM.

Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Renaming Excel sheet with Visual Basic

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump