I am importing an Access database table with the code below. During the importing process two dialog boxes (Data Link Properties & DB Initialization Information) appear. I click OK (or just hit the enter key) for both. How can I automate the "OK" so that no clicking is required? Thanks Sandy.
Please Login or Register to view this content.
Why use code when the Data Ribbon offers "From Access" and Data -> Other Sources offers MS-Query? Both of these can be set using Data -> Connections to refresh automatically on open.
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.
Thanks dflak, will give it a go. Cheers Sandy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks