Macro to Automate the updating of a Link Table (linked to excel)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
Is there anyway I can automate the process of updating linked tables (which
are currently linking to excel spreadsheets) so that the end user may only
select a button which is linked to this specific macro (which will update
certain linked tables with in the database)?

Please advise, Thanks!
 
Within Macros you would use

Deleteobject (and specify the link)
and
TransferSpreadSheet - specify link etc and supply the information.
 
Back
Top