Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an existing worksheet
Good afternoon,
Based on the following Microsoft article, I am retrieving data from SQL Server. http://msdn.microsoft.com/en-us/library/bb964684.aspx What this article does is create a a new Excel worksheet and populate that sheet with the data (roughly on page 13 of document). employeeWS = DirectCast(Me.Application.Sheets.Add(), Excel.Worksheet) employeeWS.Name = "Employees" I want to use an EXISTING worksheet, but I cannot get this to work. I have tried several options, such as using: Me.Application.Sheets("employee").Select But it either bombs there or on subsequent code (depending on other options I try). I don't want to create a NEW worksheet so how do I use the existing worksheet (the one that has the focus). Thanks in advance. It is greatly appreciated. -- Thanks, Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an existing worksheet
Hi,
Maybe this Set employeeWS = ActiveSheet employeeWS.Name = "Employees" Mike "SQLScott" wrote: Good afternoon, Based on the following Microsoft article, I am retrieving data from SQL Server. http://msdn.microsoft.com/en-us/library/bb964684.aspx What this article does is create a a new Excel worksheet and populate that sheet with the data (roughly on page 13 of document). employeeWS = DirectCast(Me.Application.Sheets.Add(), Excel.Worksheet) employeeWS.Name = "Employees" I want to use an EXISTING worksheet, but I cannot get this to work. I have tried several options, such as using: Me.Application.Sheets("employee").Select But it either bombs there or on subsequent code (depending on other options I try). I don't want to create a NEW worksheet so how do I use the existing worksheet (the one that has the focus). Thanks in advance. It is greatly appreciated. -- Thanks, Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting an existing worksheet
No, but you gave pointed me down the right path. It is this:
employeeWS = DirectCast(Me.Application.ActiveSheet, Excel.Worksheet) employeeWS.Name = "Employees" Thanks for your help Mike! Greatly appreciated. -- Thanks, Scott "Mike H" wrote: Hi, Maybe this Set employeeWS = ActiveSheet employeeWS.Name = "Employees" Mike "SQLScott" wrote: Good afternoon, Based on the following Microsoft article, I am retrieving data from SQL Server. http://msdn.microsoft.com/en-us/library/bb964684.aspx What this article does is create a a new Excel worksheet and populate that sheet with the data (roughly on page 13 of document). employeeWS = DirectCast(Me.Application.Sheets.Add(), Excel.Worksheet) employeeWS.Name = "Employees" I want to use an EXISTING worksheet, but I cannot get this to work. I have tried several options, such as using: Me.Application.Sheets("employee").Select But it either bombs there or on subsequent code (depending on other options I try). I don't want to create a NEW worksheet so how do I use the existing worksheet (the one that has the focus). Thanks in advance. It is greatly appreciated. -- Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template. | Excel Programming | |||
How do I conditionally build worksheet from existing worksheet? | Excel Discussion (Misc queries) | |||
selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
Find existing worksheet | Excel Programming |