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