| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
