Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel using Access macro
Hi
I just need to know how to open Excel from within Access. I don't need to open a file - as my Auto-Open macro does that - and it quits Excel too. An overnight scheduled task in Access creates an unformatted sheet, which I would like my Auto_Open macro to format and I'd just like Access to initiate the opening of Excel. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel using Access macro
Here's something I use...
----------------------------------------- Function fctFormatData(strMacro As String) ' Once the data is Output this fornmats the data. Personal.xls is used to hold all external macros. Dim xlsWorkbook As Excel.Workbook DoCmd.SetWarnings False Set xlsWorkbook = GetObject("c:\Book1.xls", "Excel.Sheet") xlsWorkbook.Application.Visible = True xlsWorkbook.Application.Run "PERSONAL.xls!" & strMacro, cstSite End Function ---------------------------------------------------------- HTH "Andy" wrote: Hi I just need to know how to open Excel from within Access. I don't need to open a file - as my Auto-Open macro does that - and it quits Excel too. An overnight scheduled task in Access creates an unformatted sheet, which I would like my Auto_Open macro to format and I'd just like Access to initiate the opening of Excel. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel using Access macro
Please ignore this post! I meant to post it on Access Programming - which is
what I'll do now! Cheers. Andy. <Andy wrote in message ... Hi I just need to know how to open Excel from within Access. I don't need to open a file - as my Auto-Open macro does that - and it quits Excel too. An overnight scheduled task in Access creates an unformatted sheet, which I would like my Auto_Open macro to format and I'd just like Access to initiate the opening of Excel. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro to Open Access | Excel Worksheet Functions | |||
How do I open an Access file with a macro in Excel? | Excel Programming | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
checking if an access database is open from excel macro | Excel Programming | |||
Open Ms Access database with excel macro | Excel Programming |