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

已完成
已发布大约 7 年前

€8-30 EUR

货到付款
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: 13141308

关于此项目

14提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
14威客以平均价€36 EUR来参与此工作竞价
用户头像
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 在1天之内
5.0 (379条评论)
7.3
7.3
用户头像
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 在1天之内
4.9 (119条评论)
6.2
6.2
用户头像
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 在1天之内
5.0 (41条评论)
5.0
5.0
用户头像
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 在1天之内
5.0 (4条评论)
4.2
4.2
用户头像
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 在1天之内
5.0 (4条评论)
3.5
3.5
用户头像
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 在0天之内
5.0 (8条评论)
3.2
3.2
用户头像
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 在0天之内
5.0 (5条评论)
2.5
2.5
用户头像
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 在1天之内
5.0 (4条评论)
2.3
2.3
用户头像
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 在0天之内
0.0 (0条评论)
0.0
0.0

关于客户

MOROCCO的国旗
Montreal, Morocco
4.8
3
付款方式已验证
会员自4月 18, 2010起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。