I need to Create a Macro in Access that will go to an Excel file(shared) that is already open. This file is Linked to my Access database. I need to have the macro go to this file and save it. This action will update the linked table in Access. What string of macro commands should I use?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create a Macro that will link to an open excel file
- Thread starter BillMc
- Start date
Similar threads
- Locked
- Question
