PDA

View Full Version : Solved: excel and access



philfer
12-22-2007, 11:47 AM
Let me paint a picture.

I am sitting at my desk using excel. I want to get excel to open an access DB, update links to excel worksheets using the linked table manager(there are five links but I only want to update three), run two queries and paste the results in two sheets in the workbook I started out in.

To add a twist, when I use the linked table manager I want to use the Open dialog box to allow the user to browse for the files they want to update the linked table manager with.

Can this be done?