Using Access-Excel linking

  • Thread starter Thread starter Court Smith via AccessMonster.com
  • Start date Start date
C

Court Smith via AccessMonster.com

Has anyone written a routine that takes Access table data, sends the data
to Excel for computation on a batch basis (ie opens the link, calculate,
then close the link) and returns the results to an Access table or form?
 
Although I was not involved in the development, I know it can be done. We
had a routine that took timesheet information, put it in an XL spreadsheet
so managers could allocate hours to their personnel, and returne the "Plan"
data back to Access. It worked great. Unfortunately, that company lost the
contract this was used for and closed shop in this town. Don't know if a
copy of the code survived anywhere.

Brown
 
Back
Top