Programmatically Add A New Excel Worksheet

[Hackster]

I can open and manipulate Excel workbooks easily, but I'm not faced with the task of programmatically adding a new worksheet to an existing spreadsheet. How would I do that?

 

[HarleyQuinn]

Hi,

    Dim objExcelApp As Excel.Application
    Dim xlsExcelSheet As Excel.Worksheet

    ' Create the Excel application.
    Set objExcelApp = New Excel.Application
    'nextline opens your workbook
    objExcelApp.Workbooks.Open "Your Excel Sheet"
    objExcelApp.Visible = True
    
    ' Add the Excel spreadsheet.
    [red]objExcelApp.Worksheets.Add[/red]

The bit in [red]red[/red] is how to add the worksheet.

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[Hackster]

I feel like such a dufus. I was trying (and, of course, failing) to do .AddNew

Thanks

 

[johnwm]

A general hint for VB interface with Excel is to try recording a macro in Excel first, then dissecting that code to produce what you need. It sorts out the right keywords and general syntax for you, and you can just trim to fit.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts