• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Open Multiple connections through ADODB object in excel VBA

vijay.vizzu

Member
Dear Excel Ninjas


I want to try, to open multiple connections at a same time through ADODB conn. by specifying multiple files to be accessed. Now i can able to open a single connection at a time (here i am using activeworkbook.path & application.pathseperator & activeworkbook.name) but i want to use a range of file names instead of activeworkbook.name). Can it be possible


If possible, please tell me the procedure how to acheive this.


Purpose is: i have multiple files around 10 files, i have created a summary sheet to show all models(files) status in a single sheet.


Regards

Vijay
 
Back
Top