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
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