![]() |
Creating Worksheet using Server Object
I have been successfully using the CreateObject("Excel.Application") to
create a workbook from three separate tables in a sql db. Now I want to add a 4th worksheet to the workbook, however since the default is 3 worksheets, I get an error. I use the code - .Workbooks.Add ' Adds a blank sheet set What do I need to do to add a sheet to this set? -- Olivia Towery |
All times are GMT +1. The time now is 07:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com