View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moonhk[_2_] moonhk[_2_] is offline
external usenet poster
 
Posts: 36
Default 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