VBA question create Excel Object and run XLSTART startup excel
 

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.RunAutoMacr os
xlAutoOpen
AppExcel.Visible = True
Set ExcelDocs = Nothing
Set AppExcel = Nothing

moonhkt

VBA question create Excel Object and run XLSTART startup excel
 

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


--
__________________________________
HTH

Bob

"moonhk" wrote in message
...
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.RunAutoMacr os
xlAutoOpen
AppExcel.Visible = True
Set ExcelDocs = Nothing
Set AppExcel = Nothing

moonhkt