Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Sheet Names
I'm having trouble changing the names of my worksheets in my new workbook,
can someone help? Here is the code that I have. I'm using Visual Studio 2005, Excel 2007 and VB, here is some of the code I have. Thanks! Dim LCV = New Excel._ExcelApplication LCV = CreateObject("Excel.Application") Dim oBook As Excel.Workbook Dim oBooks As Excel.Workbooks Dim oSheets As Excel.Sheets Dim oSheet1 As Excel.Worksheet oBooks = LCV.Workbooks oBook = oBooks.Add() oSheets = oBook.Worksheets <----I get an error saying COM unhandled oSheet1 = oSheets.Add oSheet1.Name = "Portfolio" I know it already has 3 sheets when you create a new workbook, but how do you change those names? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Sheet names & Workbook names in VBA coding | Excel Programming | |||
Changing Sheet Names | Excel Programming | |||
Changing VB Component Names to match Worksheet names using VBE | Excel Programming | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
changing sheet names | Excel Programming |