Open excel new blank excel workbook from MS Access

[forrestgump]

Hi All,

How do i open a new instance of an excel workbook from MS Access? I can open workbooks that are already created with the below code but not a new blank workbook:-

Set xlWB = .Workbooks.Open(Me.filepathbx & Me.lstFileList.ItemData(i))

Any help would be much appreciated.

Regards,

ForrestGump

 

[arnelgp]

Set xlWB=. Workbooks. Add

 

[isladogs]

Not sure what you have before the Set line ...

This is what I use
Slightly longer than arnel's response but it's the full code:

 Dim xlApp As Excel.Application
    Dim xlWB As Excel.Workbook
    Set xlApp = New Excel.Application
    Set xlWB = xlApp.Workbooks.Add
    xlApp.Visible = True
    xlApp.Sheets("Sheet1").Select
    xlApp.Sheets("Sheet1").name = strFileName

 

[forrestgump]

Thanks that works great!