Linking Tables through VBA

[Smithsc]

Hi,
Is it possible to call the 'Linked Table Manager' option through VBA code. I've got 2 linked excel spreadsheets which change location each month and I'm after an easy of changing them.

Any thoughts would be greatly appreciated..
Thanks

 

[JBinQLD]

g'day,

Away from my normal machine but i use something like this:

http://www.hammerdata.com/Newsgrp/tables/tbl0012.htm

Good luck mate!

JB

 

[Remou]

Depending on what you are doing, one of these may suit:

' > Access 2000
DoCmd.RunCommand acCmdLinkedTableManager

'Access 2000
Application.CommandBars("Menu Bar").Controls("Tools").Controls("Database Utilities"). _
    Controls("Linked Table Manager").Execute

'Access 2000
Application.CommandBars("Menu Bar").Controls("Tools").Controls("Database Utilities"). _
Controls("Linked Table Manager").accDoDefaultAction

 

[Smithsc]

Thank you all for your responses. I think I found an easier way:

Public Function OpenLTMDialog() As Boolean
On Error GoTo Error_OpenLTMDialog
DoCmd.RunCommand acCmdLinkedTableManager
OpenLTMDialog = True
Exit_OpenLTMDialog:
Exit Function
Error_OpenLTMDialog:
MsgBox Err & ": " & Err.Description
OpenLTMDialog = False
Resume Exit_OpenLTMDialog
End Function

This does what I need.