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

Скасований
Опублікований over 5 years ago

$30-250 USD

Оплачується при отриманні
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.
ID проекту: 17841527

Про проект

17 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
17 фрілансерів(-и) готові виконати цю роботу у середньому за $156 USD
Аватарка користувача
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 за 4 дні(-в)
4,9 (340 відгуки(-ів))
8,0
8,0
Аватарка користувача
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 за 3 дні(-в)
5,0 (202 відгуки(-ів))
7,4
7,4
Аватарка користувача
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 за 3 дні(-в)
4,8 (95 відгуки(-ів))
6,7
6,7
Аватарка користувача
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 за 3 дні(-в)
5,0 (8 відгуки(-ів))
4,9
4,9
Аватарка користувача
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 за 3 дні(-в)
5,0 (10 відгуки(-ів))
4,0
4,0
Аватарка користувача
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 за 2 дні(-в)
5,0 (9 відгуки(-ів))
3,1
3,1
Аватарка користувача
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 за 3 дні(-в)
5,0 (2 відгуки(-ів))
2,9
2,9
Аватарка користувача
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 за 3 дні(-в)
4,5 (2 відгуки(-ів))
2,7
2,7
Аватарка користувача
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 за 5 дні(-в)
5,0 (3 відгуки(-ів))
2,4
2,4
Аватарка користувача
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 за 1 день
5,0 (1 відгук)
2,1
2,1
Аватарка користувача
Will deliver required product with 100% quality
$138 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Very specific, would love to write this for you. Already have lots of functions to get started.
$138 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
North Providence, United States
5,0
10
Спосіб оплати верифіковано
На сайті з серп. 15, 2004

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.