Find Jobs
Hire Freelancers

Create an executable macro from the command line that assembles xls files into one with tabs and proper formatting

€8-30 EUR

Terminado
Publicado hace alrededor de 7 años

€8-30 EUR

Pagado a la entrega
You will need to create a Macro/Visual Basic program that must be executable from the command line (the goal is to be executable from a Python script) and that would take as an argument a directory containing a hierarchy of simple Excel files that should be processed to create one simple Excel Report. It does not involve manipulating or changing the data, but just formatting it, adding text, etc. More specifically, the program should assemble the Excel files into one Excel file, splitting the data into Tabs and adding some descriptive texts, converting dates into the proper Excel Date Format that can be filtered upon and changing some colors/doing some formating related stuff). Further and precise details will be given upon starting the project.
ID del proyecto: 13141308

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 7 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
Adjudicado a:
Avatar del usuario
Hi, I would do it this way: I would build the Excel workbook with the VBA macro inside, that would start automatically just on Workbook open (and opening of this workbook would be invoked from your Python script, as you plan). The macro would then do all the formatting as needed (it would open files indicated, copy them to single workbook, save etc.). The only problem are parameters.... The workbook and the VBA cannot accept them on opening of the workbook. So, the list of files (parameters you mentioned) would need to be passed in form of let's say txt file saved by Python script in one step before opening the Excel.\ Anyway, it is doable. Can be delivered before the end of the weekend. Regards, Jakub
€29 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
14 freelancers están ofertando un promedio de €36 EUR por este trabajo
Avatar del usuario
Hi, I am good at Excel, vb script and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
€60 EUR en 1 día
5,0 (379 comentarios)
7,3
7,3
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€100 EUR en 1 día
4,9 (119 comentarios)
6,2
6,2
Avatar del usuario
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
€30 EUR en 1 día
5,0 (41 comentarios)
5,0
5,0
Avatar del usuario
Hello, I'd be glad to create a python script that assembles the excel files instead of doing it with macros then calling it from python . Looking forward to chat with you soon for more details. Best regards,
€44 EUR en 1 día
5,0 (4 comentarios)
4,2
4,2
Avatar del usuario
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well to discuss more: ashish260287 Thanks and Regards, Ashish Singhal
€34 EUR en 1 día
5,0 (4 comentarios)
3,5
3,5
Avatar del usuario
Hi I am here to assist u inthis project I am an acca member currently wor in finance dept of Qatar Airways Have great skill and exp in excel can assist u with high regards Plz share more info to proceed Thanks Looking forward for this projext positively
€25 EUR en 0 día
5,0 (8 comentarios)
3,2
3,2
Avatar del usuario
Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable from my side as that is the sole criteria from my side to work and deliver. Hope to hear back from you soon :) #CustomerFirst Best Regards, Rohit Ahuja
€29 EUR en 0 día
5,0 (5 comentarios)
2,5
2,5
Avatar del usuario
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
€29 EUR en 1 día
5,0 (4 comentarios)
2,3
2,3
Avatar del usuario
I have already made this script after seen your Project, You can get this code, check into your system, after complete satisfaction, thn you can award me project and payment. I have spent only 30 mints to made this function, inbox me for getting this function,
€12 EUR en 0 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de MOROCCO
Montreal, Morocco
4,8
3
Forma de pago verificada
Miembro desde abr 18, 2010

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.