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

Cancelado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 17841527

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
17 freelancers están ofertando un promedio de $156 USD por este trabajo
Avatar del usuario
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 en 4 días
4,9 (340 comentarios)
8,0
8,0
Avatar del usuario
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 en 3 días
5,0 (202 comentarios)
7,4
7,4
Avatar del usuario
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 en 3 días
4,8 (95 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
5,0 (8 comentarios)
4,9
4,9
Avatar del usuario
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 en 3 días
5,0 (10 comentarios)
4,0
4,0
Avatar del usuario
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 en 2 días
5,0 (9 comentarios)
3,1
3,1
Avatar del usuario
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 en 3 días
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
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 en 3 días
4,5 (2 comentarios)
2,7
2,7
Avatar del usuario
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 en 5 días
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
Will deliver required product with 100% quality
$138 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Very specific, would love to write this for you. Already have lots of functions to get started.
$138 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
North Providence, United States
5,0
10
Forma de pago verificada
Miembro desde ago 15, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.