SO, if I create an application obhect, objExcelApp
how would I run a macro from the workbook
macro.xls called addnewsheet?

macro.xls!addnewsheet






Sub CreateExcel()
Set objExcelApp = GetObject(,"Excel.Application")
objExcelApp.Visible = True
objExcelApp.Workbooks.Add
End Sub


Lance