VBA Macro to Extract Data from Excel Workbooks

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

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.

Excel Visual Basic Data Processing Data Extraction Excel VBA

Project ID: #29842105

About the project

41 proposals Remote project Active 2 years ago

Awarded to:

(64 Reviews)
6.1

41 freelancers are bidding on average $82 for this job

asin1987

Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews he More

$100 AUD in 1 day
(288 Reviews)
8.3
schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 660 + Projects. I have 6 + years of the experience in sam More

$100 AUD in 2 days
(529 Reviews)
8.4
finecodervw

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

$75 AUD in 2 days
(177 Reviews)
6.7
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

$100 AUD in 1 day
(224 Reviews)
6.6
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed pr More

$100 AUD in 4 days
(74 Reviews)
6.1
PERPETUAL0

Hello there Are you combineed the sheet to one sheet ? thanks ilyas

$80 AUD in 1 day
(130 Reviews)
5.7
yadavexpert53

Hi, I can enhance the speed of the vba (macro) as well. Step 1 - I will give you browse button when you click on it then you need to select the folder path. Step 2 - I will give you second button called submit when More

$50 AUD in 1 day
(72 Reviews)
5.2
ShivaniGoyalsai

Hi I have 10+ years of experience in VBA programming and database management. As per requirement I can create an automation process that helps you extracting certain data from files without effecting the performance. More

$70 AUD in 3 days
(39 Reviews)
4.5
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA and ADO. It will be quick and accurate. I will start immediately and complete it with More

$50 AUD in 1 day
(26 Reviews)
5.0
globalseo614

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

$180 AUD in 3 days
(3 Reviews)
3.3
xixdia

Hi, I am an supply Chain Analyst, with more than 20 years Excel experience. I am an expert in creating tools in Excel and Access.

$75 AUD in 2 days
(2 Reviews)
2.5
mcollinscalz

Hello this is Collins and am a data processing expert. My previous projects involved the use of python tool in the extraction of data. I have reviewed your details and it entails the design of a VBA Macro tool to extra More

$150 AUD in 7 days
(1 Review)
2.2
Spacemindnahid

I have read you project thoroughly, it's quite an easy task and I can achieve this due to my experience with VBA script, it will be quick and accurate, I'll start immediately and and complete it within few hours, if in More

$75 AUD in 1 day
(1 Review)
1.1
Nishiseo

Hi, here I read your needs carefully and I was able to do this project successfully. I can do more than you need, if you need extra care of yourself please give me a touch, I will be online 24 hours to help you. You ca More

$100 AUD in 7 days
(0 Reviews)
0.0
prdlaovecka

This is a fantastic job. Can you write me a message. We can konzult toghether. Im waiting. Great regards.

$60 AUD in 1 day
(0 Reviews)
0.0
FZTrite

Hello, I read your project careful, i am pretty good experience about VBA macro. I am now working with a gov school as a part time official work like ms word, Excel, Powerpoint, Outlook, Data entry. So i have a pret More

$35 AUD in 1 day
(0 Reviews)
0.0
Waghmode1124

Hi ! I'm a excel expert, with over 3 years experience dealing with excel spreadsheet, I can help fix your scans. I've previously worked on the exact same project for another employer {link to my positive review from th More

$75 AUD in 1 day
(0 Reviews)
0.0
singhrajat026

Hello sir... I will do your work within the given time with 100%accuracy you will happy from my work... Hope you will award this project to me.... Thank you

$75 AUD in 3 days
(1 Review)
0.0
Asif1664

I have been working on Microsft Excel, Vba,Excel Marco For more than 3years.I am expertise in the following areas: Create Spreadsheets. Create automated Dashboards. Remove Duplicates. Create complicated Excel Formulas. More

$50 AUD in 7 days
(0 Reviews)
0.8
RiniYadiki

Hi I have 3years of work experience in vba. I Will be able to deliver the macro on time. looking forward to work with you.

$50 AUD in 2 days
(0 Reviews)
0.0