VBA question create Excel Object and run XLSTART startup excel

[moonhk]

Hi All


In C:\Documents and Settings\moonhkt\Application Data\Microsoft\Excel
\XLSTART have PERSONAL.xls file.

In my VBA, Winword document, have below coding.

How to include open PERSONAL.xls file ? My personal.xls have some
funcations on it.

Set AppExcel = CreateObject("Excel.Application")
Set ExcelDocs = AppExcel.Workbooks
ExcelDocs.Open FN
' ~~ExcelDocs.Application.ActiveWorkbook.RunAutoMacros
xlAutoOpen
AppExcel.Visible = True
Set ExcelDocs = Nothing
Set AppExcel = Nothing

moonhkt

 

[Bob Phillips]

Set AppExcel = CreateObject("Excel.Application")
Set ExcelDocs = AppExcel.Workbooks.Open(FN)
' ~~ExcelDocs.Application.ActiveWorkbook.RunAutoMacros
xlAutoOpen
AppExcel.Visible = True
Set ExcelDocs = Nothing
Set AppExcel = Nothing