Open Excel Using MS Access

[wandan]

Hi There,

Is there a way to open an existing Excel file from an Access database using either a macro or VBA code?

Basically, I have an Excel file that links directly to an Access table. The MS Query in Excel refreshes on open.

I would like to run my update queries in Access then have it open the Excel sheet for it to refresh then save and close it.

Sounds simple enough, but all I can find it OutputTo which is not exactly what I am looking for.

Thanks.

 

[PHV]

You may try something like this:
Dim myWB As Object
Set myWB = GetObject("\path\to\workbook.xls")
DoEvents
myWB.Save
myWB.Close
Set myWB = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886