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

Completed
Posted about 7 years ago

€8-30 EUR

Paid on delivery
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.
Project ID: 13141308

About the project

14 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 day
0.0 (0 reviews)
0.0
0.0
14 freelancers are bidding on average €36 EUR for this job
User Avatar
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 day
5.0 (379 reviews)
7.3
7.3
User Avatar
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 day
4.9 (119 reviews)
6.2
6.2
User Avatar
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 day
5.0 (41 reviews)
5.0
5.0
User Avatar
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 day
5.0 (4 reviews)
4.2
4.2
User Avatar
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 day
5.0 (4 reviews)
3.5
3.5
User Avatar
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 day
5.0 (8 reviews)
3.2
3.2
User Avatar
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 day
5.0 (5 reviews)
2.5
2.5
User Avatar
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 day
5.0 (4 reviews)
2.3
2.3
User Avatar
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 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MOROCCO
Montreal, Morocco
4.8
3
Payment method verified
Member since Apr 18, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.