Create Blank Excel file Programmatically

S

Sarah

Hi,

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

Thanks,

Sarah
 
D

Douglas J. Steele

Dim appExcel As Object

Set appExcel = CreateObject("Excel.Application")
appExcel.Application.Workbooks.Add
appExcel.Visible = True
 
S

Sarah

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...
 
Top