VBA to send keys automatically

[maabbas]

Hello everyone,

I am using the following code to open the Linked Table Manger,

Private SubPrivate Sub Form_Load()Application.CommandBars("Menu Bar").Controls("Tools").Controls("Database Utilities"). _
    Controls("Linked Table Manager").Execute
End Sub

I want to send Alt+S, and OK command to the linked table manger so, user don't have to worry about any thing. I use the

SendKeys "%S"

code at the end of above code but it is not working, will some one help me out.

Thanks

 

[maabbas]

I got it, using the Macro builder to send Keys and run Menu Command.

 

[xenou]

Depending on what you are trying to do, you don't necessarily need to use send keys. For instance, you can change linked tables programmatically (if you know the target addresses).