Find Jobs
Hire Freelancers

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

$15-25 CAD / hour

Lezárt
Kiadva ekkor: több mint 5 évvel ezelőtt

$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>
Projektazonosító: 17725099

A projektről

35 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
35 szabadúszó adott átlagosan $20 CAD/óra összegű árajánlatot erre a munkára
Felhasználó avatár
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 40 napon belül
4,9 (435 értékelés)
8,2
8,2
Felhasználó avatár
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 40 napon belül
4,9 (166 értékelés)
7,7
7,7
Felhasználó avatár
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 40 napon belül
4,9 (302 értékelés)
7,3
7,3
Felhasználó avatár
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 25 napon belül
4,9 (455 értékelés)
7,6
7,6
Felhasználó avatár
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$20 CAD 40 napon belül
4,9 (132 értékelés)
7,1
7,1
Felhasználó avatár
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 18 napon belül
5,0 (121 értékelés)
6,5
6,5
Felhasználó avatár
phd in computer science having seven years of experience in Excel development and visual basics.
$25 CAD 1 napon belül
4,7 (93 értékelés)
6,4
6,4
Felhasználó avatár
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 10 napon belül
4,9 (104 értékelés)
6,1
6,1
Felhasználó avatár
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 11 napon belül
4,9 (89 értékelés)
5,6
5,6
Felhasználó avatár
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 40 napon belül
4,9 (34 értékelés)
5,6
5,6
Felhasználó avatár
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 40 napon belül
4,8 (13 értékelés)
5,3
5,3
Felhasználó avatár
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 40 napon belül
4,9 (30 értékelés)
4,9
4,9
Felhasználó avatár
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 40 napon belül
4,9 (57 értékelés)
5,0
5,0
Felhasználó avatár
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 30 napon belül
5,0 (5 értékelés)
4,4
4,4
Felhasználó avatár
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 43 napon belül
5,0 (3 értékelés)
2,9
2,9
Felhasználó avatár
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 30 napon belül
2,3 (6 értékelés)
4,1
4,1
Felhasználó avatár
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 40 napon belül
0,0 (0 értékelés)
0,8
0,8
Felhasználó avatár
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 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have written macros in excel for 3 projects and have completed the task with user satisfaction
$22 CAD 10 napon belül
0,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
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 40 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

CANADA zászlója
Terrebonne, Canada
0,0
0
Tagság kezdete: szept. 7, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.