Create Blank Excel file Programmatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Does anyone know how to programmatically create a blank excel file with the
3 standard worksheets (sheet1, sheet2, sheet3)?

Thanks,

Sarah
 
Dim appExcel As Object

Set appExcel = CreateObject("Excel.Application")
appExcel.Application.Workbooks.Add
appExcel.Visible = True
 
Thanks Doug... that worked great!

Sarah

Douglas J. Steele said:
Dim appExcel As Object

Set appExcel = CreateObject("Excel.Application")
appExcel.Application.Workbooks.Add
appExcel.Visible = True
Click to expand...
 
Back
Top