Hi
I recorded a macro that should connect a table in my workbook to different Access databases. I changed some of the code so that it finds the filepath in a cell in one of the worksheets. The code works fine on meny different Access databases. But not on others. I can't figure out why...
Please Login or Register to view this content.
The best thing to do with a connection string is to get the string, break it into pieces, change the parts you want and put them back together.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks