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

Abgeschlossen
Veröffentlicht vor etwa 7 Jahren

€8-30 EUR

Bezahlt bei Lieferung
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.
Projekt-ID: 13141308

Über das Projekt

14 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
14 Freelancer bieten im Durchschnitt €36 EUR für diesen Auftrag
Avatar des Nutzers
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 in 1 Tag
5,0 (379 Bewertungen)
7,3
7,3
Avatar des Nutzers
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 in 1 Tag
4,9 (119 Bewertungen)
6,2
6,2
Avatar des Nutzers
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 in 1 Tag
5,0 (41 Bewertungen)
5,0
5,0
Avatar des Nutzers
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 in 1 Tag
5,0 (4 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 in 1 Tag
5,0 (4 Bewertungen)
3,5
3,5
Avatar des Nutzers
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 in 0 Tag
5,0 (8 Bewertungen)
3,2
3,2
Avatar des Nutzers
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 in 0 Tag
5,0 (5 Bewertungen)
2,5
2,5
Avatar des Nutzers
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 in 1 Tag
5,0 (4 Bewertungen)
2,3
2,3
Avatar des Nutzers
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 in 0 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von MOROCCO
Montreal, Morocco
4,8
3
Zahlungsmethode verifiziert
Mitglied seit Apr. 18, 2010

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.