Find Jobs
Hire Freelancers

Developer needed for creating Macro VBA that could read an Excel file, and produce a report .

$15-25 CAD / hour

Cerrado
Publicado hace más de 5 años

$15-25 CAD / hour

Specification for the Macro 1. Description of the Project Excel integrates a programming language, VBA, which allows to realize powerful and user-friendly applications, example a Macro, is an achievement of this product. Since it’s possible to use the macro for a sequence of tasks within a software program, it’ll be used for daily reports of inspections from Praxedo (SAS). 2. Use case I. User Case Download ODT File on Praxedo Needs Produce monthly reports with all 5 inspections collected by the technicians Scope Applications Must Macro available on user’s PC Dependency Excel Trigger Have the macro available in all open Excel workbooks « [login to view URL] » DESCRIPTION Steps Action 1 The user downloads the CSV file on Praxedo and save it on his PC 2 Launch the Macro, and follow the instruction on the homepage-Macro. 3 Click on the "Inspections Report" button located on the homepage-Macro. 4 The system generates 5 Excel sheets for each inspection. EXCEPTIONS Steps Action 1a <Excel file not saved on the PC>: <The application returns an error message> 2a <Instruction not respected on the homepage-Macro >: <The application returns an error message> II. Developer Case Creating the Macro Needs Develop a Macro that could read an Excel file, and produce a report from the specific column data. Scope Applications Must The macro must be able to list the CSV file on the user’s PC. Dependency Can read excel version of Microsoft Office (XLSX) Trigger Have a button « Inspections Report » located on the Home page of the Macro. DESCRIPTION Steps Action 1 Create a Button « Inspection Report » on the Sheet Homepage-Macro in cell “C6” 2 This button will be the trigger that will read the user’s csv file at the «G3 » address of homepage-Macro sheet. 3 The application should automatically generate another new sheet exceel with the desired table. EXCEPTIONS Steps Action 2a < Excel file not saved on the PC>: <The application returns an error message>
ID del proyecto: 17725099

Información sobre el proyecto

35 propuestas
Proyecto remoto
Activo hace 5 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
35 freelancers están ofertando un promedio de $20 CAD /hora por este trabajo
Avatar del usuario
Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Developer needed for creating Macro VBA that could read an Excel file, and produce a report .. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$20 CAD en 40 días
4,9 (435 comentarios)
8,2
8,2
Avatar del usuario
Hi there,I am Miljan,Excel Macro/VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$22 CAD en 40 días
4,9 (166 comentarios)
7,7
7,7
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$25 CAD en 40 días
4,9 (302 comentarios)
7,3
7,3
Avatar del usuario
Hello Louis, I have checked the details given in document and understood your requirement. I have 2.5 years experience in Excel VBA Macro programming I can complete task within time with 100% accuracy. With Regards, Sai
$15 CAD en 25 días
4,9 (455 comentarios)
7,6
7,6
Avatar del usuario
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$20 CAD en 40 días
4,9 (132 comentarios)
7,1
7,1
Avatar del usuario
I have solid experience with excel macro/VBA development, and have worked on similar projects before, I can write the macro to generate the report as requested. If you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project
$16 CAD en 18 días
5,0 (121 comentarios)
6,5
6,5
Avatar del usuario
phd in computer science having seven years of experience in Excel development and visual basics.
$25 CAD en 1 día
4,7 (93 comentarios)
6,4
6,4
Avatar del usuario
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$20 CAD en 10 días
4,9 (104 comentarios)
6,1
6,1
Avatar del usuario
Hi there! Have done this type of job before, have excellent Excel/VB Macro skills, and am available to do this. Let me know, thanks! -Steve
$25 CAD en 11 días
4,9 (89 comentarios)
5,6
5,6
Avatar del usuario
Hi, I have experience more 10 years in Excel and VBA , so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
$22 CAD en 40 días
4,9 (34 comentarios)
5,6
5,6
Avatar del usuario
Hello! This is white horse Technologies and I was glad to see that you're looking for help for project Macro VBA that could read an Excel file, and produce a report. I've delivered more than 40 projects in the last 1 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$25 CAD en 40 días
4,8 (13 comentarios)
5,3
5,3
Avatar del usuario
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$22 CAD en 40 días
4,9 (30 comentarios)
4,9
4,9
Avatar del usuario
Hi Good day! I can help you to complete this project, I already read your requirements based on this post and the attached word document. Do you have any existing so I can assess how long would it take to complete this. I am VBA Macro developer and has a strong knowledge with MS Excel functions and formulas. Feel free to message me anytime to discuss more. Thanks
$15 CAD en 40 días
4,9 (57 comentarios)
5,0
5,0
Avatar del usuario
Hello saintlouis9, I have go through your project "Developer needed for creating Macro VBA that could read an Excel file, and produce a report ." We have a team of experts with global reach and available to work on your project. Relevant Skills and Experience I have 10+ years of experience in Excel, Software Architecture, VB.NET, Visual Basic, Visual Basic for Apps I can do this within your budget too $15 - $25 CAD / hour please check more from here https://www.freelancer.com/u/mmadi.html?page=portfolio I am ready to work with you,kindly waiting for your response. Thanks & Regards, Mmadi Specification for the Macro 1. Description of the Project Excel integrates a programming language, VBA, which allows to realize powerful and user-friendly applications, example a Macro, is an achievement of this product. Since it’s possible to use the macro for a sequence of tasks within a software program, it’ll be used for daily reports of inspections from Praxedo (SAS). 2. Use
$15 CAD en 30 días
5,0 (5 comentarios)
4,4
4,4
Avatar del usuario
Hi,I have read your requirements of Developer needed for creating Macro VBA that could read an Excel file, and produce a report . and send emaila and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.
$21 CAD en 43 días
5,0 (3 comentarios)
2,9
2,9
Avatar del usuario
Hi there, excel macro is a powerful tool that will able to generate reports and accomplish task just a click of a button. This cab create 5 sheets and process csv file based on your requirements. I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
$22 CAD en 30 días
2,3 (6 comentarios)
4,1
4,1
Avatar del usuario
Hi There! I can see that you're looking someone to build a Macro that can streamline your day-to-day functionalities. Well, I do have several years of experience and would be more than happy to discuss more details with you. Sincerely,
$22 CAD en 40 días
0,0 (0 comentarios)
0,8
0,8
Avatar del usuario
All projects handled by using PMP style of work. And more advanced technology can be used like RPA (ROBOTIC PROCESS AUTOMATION ) LIKE Uipath tool. For RPA charges would be different. Relevant Skills and Experience I have made such kind of dashboard for my previous organization.
$22 CAD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have written macros in excel for 3 projects and have completed the task with user satisfaction
$22 CAD en 10 días
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
I have a master degree of Financial Engineering. I have lots of experiences with various technical software, especially programming ones like SAS and VBA. Also I did lots of projects required various data processing and document generating with error-free delivery. I can complete this task using much less time than others and give you exact what you want. Let me know if you need my help. Thank you for you time and look forward to your response.
$15 CAD en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Terrebonne, Canada
0,0
0
Miembro desde sept 7, 2018

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.