Update Excel file

[BrianK]

I have a linked Excel file in my Access db. I would like
to update the Excel file either upon opening up a form or
perhaps a manual command button. The problem is that I
don't want to actually open Excel and pull up the file
but would rather it happen "behind the scenes". Is there
a way to do this programically?

 

[John Nurick]

Hi Brian,

You can use Automation to control Excel from VBA code running in Access.
The following links show the basics:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(142476)
http://support.microsoft.com/?id=142476

There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235