| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link, drop link, relink
Hi,
I have a connection to an Access 2010 query that is linked to an Excel 2010 table. I would like to use VBA to establish the link to the Access query, refresh the Excel table, then drop the link. This way Excel users have current data (updated monthly) and I don't have to be concerned that they might be connected to the database while the monthly updates to Access are in progress. I could import but the Access database is in a remote location so it would be slower. Thanks for any ideas. Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Link drop-down list? | Excel Discussion (Misc queries) | |||
| To Link drop-down list | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| How do you link 2 drop-down menus? | Excel Programming | |||
| Link To Drop Down Menu | Excel Worksheet Functions | |||
Threaded Mode
