I require a VBA macro to loop through multiple workbooks using the filename to extract data from specific cells. I would like this to be setup using an ADO connection in VBA rather than opening the workbook to improve the speed of this macro.
42 freelanceria on tarjonnut keskimäärin $81 tähän työhön
Hi, I am well versed with Excel VBA as well as ADO connection and can help to loop through multiple workbooks and extract the required data. A quick discussion would help. Looking forward to your response. Thanks
Dear Employer, I can crate VBA Macro to Extract Data from Excel Workbooks. I have good experience in VBA. Kindly click on chat for discussion. Regards, Sunil