Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force VBA to create an Excel.Application object of specified version of Excel? | Excel Programming | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
Question about opening workbooks on Excel startup | Excel Programming | |||
using create object and sendkeys from excel to FTP | Excel Programming | |||
How to create a PASSWORD ENTRY BOX at startup of Excel Application | Excel Programming |