Annulleret

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.

Evner: Excel, VBScript, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 10 bedømmelser ) North Providence, United States

Projekt ID: #17841527

22 freelancere byder i gennemsnit $153 på dette job

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( Flere

$200 USD in 2 dage
(631 bedømmelser)
8.3
deepbluetech

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 Flere

$250 USD in 3 dage
(198 bedømmelser)
7.3
schoudhary1553

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 Flere

$250 USD in 4 dage
(274 bedømmelser)
7.6
polarjin2017

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 Flere

$155 USD in 3 dage
(54 bedømmelser)
6.2
Developer000

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] Flere

$150 USD in 3 dage
(12 bedømmelser)
4.5
vijayvizzu7

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 dage
(6 bedømmelser)
3.8
shiningdevelopor

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 Flere

$50 USD in 3 dage
(3 bedømmelser)
3.6
brianconey

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 Flere

$155 USD in 3 dage
(3 bedømmelser)
3.7
jperusan

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 Flere

$60 USD in 2 dage
(8 bedømmelser)
3.0
dinhfreedom

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 Flere

$200 USD in 3 dage
(2 bedømmelser)
2.7
pnjadhav

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 Flere

$250 USD in 5 dage
(3 bedømmelser)
2.4
Argha02

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 Flere

$30 USD på 1 dag
(1 bedømmelse)
2.1
idragon712

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 Flere

$250 USD in 3 dage
(1 bedømmelse)
2.0
general985

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 Flere

$150 USD in 3 dage
(1 bedømmelse)
0.6
AdrianCJ

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 Flere

$60 USD in 3 dage
(1 bedømmelse)
0.8
creativesoft7

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 Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
Baner041986

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 dage
(0 bedømmelser)
0.0
Goumzy

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 Flere

$138 USD in 3 dage
(0 bedømmelser)
0.0
akweb2015

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 dage
(0 bedømmelser)
0.0
dungforever

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 Flere

$100 USD in 3 dage
(0 bedømmelser)
0.0