Linking and updating with Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a relatively large Excel file with complex calculations between cells
and worksheets. Linking to the worksheets indeed allows me to analyse and
work on the data, however, updating data from Access doesn't trigger the
chain of updates as in Excel (unless you issue a save record command), and of
course, Excel must be running the same file simultaneously for that to happen.
Is there a way to avoid having Excel open together with the Access
application and still enjoy the spreadsheet services?

TIA
 
Hi Moty,

Excel needs to be open to recalculate the formulas. However you can use
Access VBA code to open a hidden instance of Excel and manipulate the
workbook with that. The following links should get you started. Even if
they say they are for Access 97 and 2000 they apply about 99.5% to later
versions too:

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

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

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

White paper and code samples
http://support.microsoft.com/?id=253235
 
Back
Top