bobdole22
08-29-2013, 08:54 AM
Hello everyone. I love your forum, and it's helped me a ton at my new job. I have (hopefully) a simple question for you guys.
My excel page displays some access tables. The problem is the path is invalid after moving to another computer. I am going to have a VBA button so they choose the database they want to display. Then it will change the link, and refresh.
I have all of that code worked out except changing the linked databases filepath. I have the filepath saved to a variable, but I'm not sure what to do with it. Can anyone direct me in the right direction? Keep up the good work. Thanks guys!
My excel page displays some access tables. The problem is the path is invalid after moving to another computer. I am going to have a VBA button so they choose the database they want to display. Then it will change the link, and refresh.
I have all of that code worked out except changing the linked databases filepath. I have the filepath saved to a variable, but I'm not sure what to do with it. Can anyone direct me in the right direction? Keep up the good work. Thanks guys!