Find Jobs
Hire Freelancers

Use VBSCRIPT to extract various details of a complete directory of Excel .xlsx files into a CSV output file

$30-250 USD

Cancelled
Posted over 5 years ago

$30-250 USD

Paid on delivery
Use VBSCRIPT as the programming language in a .vbs file to extract various details of a complete directory of dozens of Excel .xlsx files each with multiple Worksheet Tabs in every Excel file each containing multiple Column Name Headers into a single CSV file with a single row for each of the unique Excel .xlsx Worksheet Tabs in the Workbook and all the Column Names contained in that Worksheet Tab formatted as follows for each row: ExcelWorkBookFileName, ExcelFileDate,ExcelTab1Name,ColumnName1,ColumnName2,ColumnName3, ColumnName4,ColumnName5,..... Columname999 where there could be as many as 175 Column Names in a WorkSheet Tab. Then for the 2nd Worksheet Tab and all the other Worksheet Tabs (with up to 20 Tabs in a single WorkBook) repeat the same information in the 2nd row of the output CSV File named using the core ExcelWorkBookFileName plus a DateTimeStamp like 20180930_1115am with a .CSV file extension written into the directory where the .vbs is being executed which will be on a local laptop. The remote directory containing all the .xlsx files could be as long as 50 characters which will be hard coded into the .vbs script or passed in as a parameter: For instance: J:\Kerwin\CDCData\RawData\Sep2018\ExcelFiles ExcelWorkBookFileName, ExcelFileDate,ExcelTab2Name,ColumnName1,ColumnName2,ColumnName3, ColumnName4,ColumnName5,..... Columname999 ExcelWorkBookFileName, ExcelFileDate,ExcelTab3Name,ColumnName1,ColumnName2,ColumnName3, ColumnName4,ColumnName5,..... Columname999 and so on until between 10 and 20 Tabs have been processed.
Project ID: 17841527

About the project

17 proposals
Remote project
Active 6 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
17 freelancers are bidding on average $156 USD for this job
User Avatar
Hello, Hope you are doing well. I can help with your project Use VBSCRIPT to extract various details of a complete directory of Excel .xlsx files into a CSV output file. I can assure you the quality job. I have good experience in Excel, VBScript, Visual Basic. We have worked on several similar projects before! Please have a look at my portfolio below: https://www.freelancer.com/u/schoudhary1553 We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD in 4 days
4.9 (340 reviews)
8.0
8.0
User Avatar
Hi, I am an Excel automation expert and can provide you with the vbscript meeting your requirements. Would request you to provide a sample folder containing the input Excel files. Can I expect all the column headers to be exact replicas in each of the similar Tabs ? Let me know if you are interested. Cheers, Arul
$250 USD in 3 days
5.0 (202 reviews)
7.4
7.4
User Avatar
Hi there. How are u? I saw your project description carefully and i understand what u want . I have rich experience in vbscript so i can do your project perfectly. And tell about my top skills , i have good knowledge in C#, C++/C,java, swift, PHP,CSS, angular, node, react so i have many kinds of fields knowledge, your probject is no problem for me. If u wold like to choose me, i do my best. Thanks.
$155 USD in 3 days
4.8 (95 reviews)
6.7
6.7
User Avatar
Hello How are you My name is Xu as vbscript exeprt and I am sure I can build script as your requriement i have full time and I can start to work immediately Please contact me and do let us discuss about your project Thanks for your posting
$155 USD in 3 days
5.0 (8 reviews)
4.9
4.9
User Avatar
Hi, I read your description and understood your requirement. I have years of experience in VBA, VBScripting and other office integration development. I am sure i can handle your request
$120 USD in 3 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Hello. I am making a lot of scripts in many scripting languages, and VBScript is definitely one of them so I won't have problem to make what you need. Please contact me if you have any questions. Thanks for reading my proposal. UPDATE: I had some spare time so I already made script. It did not take much time so I've adjusted the price.
$60 USD in 2 days
5.0 (9 reviews)
3.1
3.1
User Avatar
I can complete this project, I am using VBScript on a daily basis at my work. One thing I would say is that it tends to be very slow for very large files (175 columns x 20 tabs as you say). But if vbs is a must we could use it
$60 USD in 3 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Dear sir. Your project attracted my attention at first glance, because I've extensive experience in VB Script Programming. I'm really confident about your project, and very eager to join your project. If we have a chance to cooperate, I'll do my best to provide wonderful result. Looking forward to your response. Best Regards.
$200 USD in 3 days
4.5 (2 reviews)
2.7
2.7
User Avatar
Please review my profile I am working with skills that you required for this job for 16 years. I am working with MS Access, Excel, MS SQL, VBA and .Net for a long time. I can definitely help you with this job, to make your database design very proficient. I have done lots of split databases with MS Access to Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. I will show my advanced skills in MS Access/Excel via arranging demo via screen sharing session etc. Please contact me with your interest in my profile to discuss next.
$250 USD in 5 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi, I will deliver the project within 1 day of winning the bid. I am a computer science engineer with 7 years of work experience in a leading IT company with hands on experience in Excel VBA programming. I have successfully finished various Excel automation projects including Automated HR dashboard, Automated MIS tracker etc. I am passionate about providing quality deliverable in a time bound manner thus creating client ecstasy.
$30 USD in 1 day
5.0 (1 review)
2.1
2.1
User Avatar
Will deliver required product with 100% quality
$138 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I understood your requirement. I am an expert in Excel and programming. Please give me an opportunity to work with you. Also please let me know if any error occurs while reading and creating csv files do you need any kind of features like maintain status, pause, resume restart from where it left, etc options. Thanks, Gautam.S
$138 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Very good day, my name is Abner Velasco, I am a VB programmer with more than 12 years of experience working for Multinational Companies, it will be a pleasure to help you with your project.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Very specific, would love to write this for you. Already have lots of functions to get started.
$138 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Providence, United States
5.0
10
Payment method verified
Member since Aug 15, 2004

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.