Linking Certain Access fields into specific Excel Column

[Edgardo Rivera via AccessMonster.com]

Hey,
I am trying to link a specific field from an Access form into a an existing Excel column. But I want the link to be 'triggered' when certain data is inputted into the access field and create a chain of events in Excel. Any info is certainly appreciated if any.
Thanks

 

[John Nurick]

Hi Edgardo,

One way of doing this is to use code in the Access form (probably the
AfterUpdate event of the control that displays the data you're
interested in) to automate Excel.

Here's a useful article giving the basics of controlling Excel from
Access:
http://www.mvps.org/access/modules/mdl0006.htm

Here's another:

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

and a web or newsgroup search will find much more.

Hey,
I am trying to link a specific field from an Access form into a an existing

Excel column. But I want the link to be 'triggered' when certain data
is inputted into the access field and create a chain of events in Excel.
Any info is certainly appreciated if any.

 

[Edgardo Rivera via AccessMonster.com]

Much Thanks John I will try them out and see if I have any luck.