M
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
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