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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of Linking Tables 2
Linked Excel File won't update 1
Linked Excel spreadsheet to be used as table 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Break the linked tables 6
linking tables and relationships 3
Changing Links to access databases 1
linked tables 2007 <--> 95 4

Back
Top