VBA Refresh Excel Link Table

[shamas21]

Hi All

I have a link Table to an Excel spreadsheet called 'tblLinkTable'.

I want to refresh the specific table automatically in VBA.

Ive got as far as:

RunCommand acCmdLinkedTableManager

this only opens the lnik table manager but i need it to automatically Update the 'tblLinkTable' Table.

Can someone help please?

Thanks

 

[Alisa]

you can do this in code:

Dim tdf As DAO.TableDef
  
  Set tdf = Currentdb.TableDefs("YourTableName")
  tdf.RefreshLink
  Set tdf = Nothing