update linked table automatically

[David B]

Is there a way to update the link to an Excel spreadsheet without going
through the Linked Table Manager? Thanks.

 

[Klatuu]

Can you be more specific?
When do you want to do link?
Will the Excel file always be in the same folder and have the same name?

 

[John Nurick]

Hi David,

This may help: http://www.mvps.org/access/tables/tbl0009.htm

 

[DALIA AMAYA]

Is there a way to update the link to an Excel spreadsheet without going
through the Linked Table Manager? Thanks.

 

[David B]

The tables will not move. They're for an instrument usage log, and after
about a month, the current table will be static, and a new one will be active
and changed. I want to update the links when the db is opened, mainly at the
time the monthly report is created.

I missed the MVP article that John posted. I'll check that code as well as
the replies here. Thank you.