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.
Bu iş için 22 freelancer ortalamada $153 teklif veriyor
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 ( Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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] Daha Fazla
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
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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.
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 Daha Fazla
Hello, I can make vbs macro for you to make csv from excel file. Ready to start to work right away. Thank you.
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 Daha Fazla