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

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.

Skills: Excel, VBScript, Visual Basic

See more: convert excel files to csv automatically, export multiple excel sheets to text file, excel export multiple sheets to text, macro to convert multiple excel files to csv, excel export multiple sheets to csv, excel export sheet to csv vba, export multiple worksheets to one csv, excel export multiple sheets to csv mac, use php extract parse websites, vbscript extract data access mdb, transcribe directory excel, php extract page details, vbscript extract ole object data type table, vbscript extract values xls files, use regex extract values html, address directory excel, reading text files directory excel macro, extract data yellow pages directory, file directory excel macro, auto directory excel

About the Employer:
( 10 reviews ) North Providence, United States

Project ID: #17841527

22 freelancers are bidding on average $153 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$200 USD in 2 days
(631 Reviews)

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 More

$250 USD in 3 days
(198 Reviews)

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 hav More

$250 USD in 4 days
(274 Reviews)

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 knowle More

$155 USD in 3 days
(54 Reviews)

Feel fee to contact me for Use VBSCRIPT to extract various [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] More

$150 USD in 3 days
(12 Reviews)

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
(6 Reviews)

Hello How are you I read your description carefully Very interesting I have many good experiences in VBA So I can finish your project quickly and perfectly If you hire me, I will do my best and make you satisfied More

$50 USD in 3 days
(3 Reviews)

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 pr More

$155 USD in 3 days
(3 Reviews)

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 More

$60 USD in 2 days
(8 Reviews)

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 c More

$200 USD in 3 days
(2 Reviews)

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 ma More

$250 USD in 5 days
(3 Reviews)

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 suc More

$30 USD in 1 day
(1 Review)

Hello I am a senior software engineer and have great interest to your job. I have read your job description from start to end and was impressed with your detailed requirement. Visual Basic language is one of my stro More

$250 USD in 3 days
(1 Review)

Hello sir. I'm excited about your project, because I've really rich experience in VB Programming. I've developed many projects similar to yours and excellent skills. If you award me, I'll provide wonderful result on More

$150 USD in 3 days
(1 Review)

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 coul More

$60 USD in 3 days
(1 Review)

Hi, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have got Rich experience in Jooml More

$155 USD in 3 days
(0 Reviews)

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 Reviews)

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 n More

$138 USD in 3 days
(0 Reviews)

Hello, I can make vbs macro for you to make csv from excel file. Ready to start to work right away. Thank you.

$277 USD in 3 days
(0 Reviews)

How are you, Dear sir/madam? It's very worthwhile chance for me to let you know my skills and proposal about this project. I am an honest developer who have rich experiences in vbscript for data extracting. I ha More

$100 USD in 3 days
(0 Reviews)