Adding new worksheets to excel from access 1

[robojeff]

Is there way to add new worksheets to an excel spreadsheet from Access and at the same time name the sheet?

If so, how might I add a worksheet titled, "New Sheet"?

thank you

 

[PHV]

How is your access application monitoring excel ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ccs199]

Have you tried a keyword search on create excel sheet? I'm sure that this question has been asked many times.

 

[robojeff]

PHV (MIS) 24 Feb 09 16:26
How is your access application monitoring excel ?

Not familiar with the term "monitoring" but I am using automation to populate the excel worksheets (sample below)but find that I need to add a couple more worksheets...

Dim objXLSheet As Excel.Worksheet
Set objXLSheet = objXLBook.Worksheets("Sheet1")

 

[PHV]

Set objXLSheet = objXLBook.Worksheets.Add
objXLSheet.Name = "new name here"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886