Linking Certain Access fields into specific Excel Column

  • Thread starter Thread starter Edgardo Rivera via AccessMonster.com
  • Start date Start date
E

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
 
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
Click to expand...
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.
 
Much Thanks John I will try them out and see if I have any luck.
 
Back
Top