Find Jobs
Hire Freelancers

Excel VBA code

$50-100 USD

Completed
Posted about 5 years ago

$50-100 USD

Paid on delivery
I want an Excel VBA Code/ macro that will count all the active rows in a specific column within a number of closed workbooks (Sheet1) & text files (i.e. txt & csv). The file path will be as followed “C:\TestFolder”. This file path contains over 100 spreadsheets & text files so the code/ macro must be able to loop through each file. The macro/ code must be able to open up each file in the background & close the files automatically. The Macro must be able to loop through each file (data is kept in sheet1 for workbooks) and count the total number of active rows in a specific column (for example column A, B or C) & it must be able to print this value within a separate workbook ‘zMasterworkbook’. The code or macro must also be compatible with older versions of excel. The separate workbook ‘zMasterworkbook’ must contain and meet the following requirements: 1. Column A2- should have the ‘File Name’ field (file name of each file) 2. Column B2- should have ‘Total number of Active Rows” filed (total number of active rows for a specific column in each file).
Project ID: 18735039

About the project

12 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$65 USD in 1 day
4.9 (304 reviews)
6.7
6.7
12 freelancers are bidding on average $72 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$120 USD in 2 days
4.9 (320 reviews)
7.8
7.8
User Avatar
Dear Employer, I understand you need a macro code which will check all the excel files in a Test folder in C drive and will find the active cells in different columns and will give the values in Col A2 and B2. Please message me and give me an opportunity to work on your project. I understand it well and will do a perfect job for you. Thanks and Regards, Ash
$100 USD in 5 days
5.0 (157 reviews)
7.3
7.3
User Avatar
I can do Excel VBA Code/ macro that will count all the active rows in a specific column within a number of closed workbooks (Sheet1) & text files (i.e. txt & csv). MOhsan
$75 USD in 1 day
5.0 (80 reviews)
6.2
6.2
User Avatar
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you for further discussion. Kind regards Rina
$50 USD in 10 days
4.9 (81 reviews)
5.9
5.9
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
$50 USD in 1 day
5.0 (94 reviews)
6.0
6.0
User Avatar
I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to count row number of all files as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to chat further and work on your project.
$80 USD in 2 days
4.9 (74 reviews)
5.6
5.6
User Avatar
Hello. How are you? I am highly interested to work on the "Excel VBA code". I am a full stack Excel expert. I have more than 7 years experience in "Data Processing, Excel, Visual Basic, Visual Basic for Apps". I will make sure the best quality service. Let us work together. Best regards, Yang L.
$50 USD in 1 day
4.7 (42 reviews)
5.5
5.5
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$75 USD in 10 days
5.0 (24 reviews)
4.7
4.7
User Avatar
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$50 USD in 1 day
5.0 (29 reviews)
4.0
4.0
User Avatar
Hi Sir, I see you need Macro Programming in excel to help you deal with the data in CSV, Excel and TXT files. I can help you with that. I've been desigining macros since long. for the confirmation, i need to see the TXT file and CSV format. CSV is same as Excel. Only thing to confirm is TXT file template. Let's discuss more about this in chat. I'm available and can start work on it right away. I'd like to see dummy data also to check the data arrangement in the sheet. Lets discuss this in chat.
$100 USD in 5 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hello, Wish you a very good day. I have gone through your job post and come to know that you are looking for an Excel VBA Developer. As it is a passion of me working as an Excel Data Entry, I don’t want to lose the opportunity and therefore applying for the post. I have completed graduated in ICT and having 5+ years of experience In excel data entry work. I believe myself to be the most reliable person for your job. If I awarded then I will instantly start & give you complete project within 24 hours. I am working as a freelancer and as a Virtual Assistant for a long five years. It has made me many experts in my work. I work in such an environment and enjoy the variety of works the job brings each day. I can assure you that if you hire me, I will give you quality work & you will get a good staff for your any data entry project. Thanks a lot for taking time reviewing the letter. I hope to hear from you soon. Best Regards Monir
$50 USD in 1 day
5.0 (2 reviews)
2.5
2.5

About the client

Flag of UNITED KINGDOM
luton, United Kingdom
5.0
4
Payment method verified
Member since Jul 20, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.