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

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] »



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.


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.


1 Create a Button « Inspection Report » on the Sheet Homepage-Macro in cell “C6”


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.


2a < Excel file not saved on the PC>:

<The application returns an error message>

Kemahiran: Excel, Kejuruteraan Perisian, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: read excel file javascript, read excel file , read excel file mysql, macros for dummies excel, how to make macro in excel, how to generate reports in excel using macros, using macros to automate data entry in excel, how to create a macro name in excel, how to make a macro, what is the third step in creating a macro in excel?, using macros in excel, access read excel file, spring read excel file, visual basic net read excel file access, read excel file servlet, macro copy paste excel file, php read excel file, java read excel file, read excel file using, script php read excel file

Tentang Majikan:
( 0 ulasan ) Terrebonne, Canada

ID Projek: #17725099

37 pekerja bebas membida secara purata $20/jam untuk pekerjaan ini


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 Lagi

$20 CAD / jam
(299 Ulasan)

Hello, I am ready to write code in VB for given excel file. Can we discuss in details? Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) Lagi

$25 CAD / jam
(203 Ulasan)

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. Lagi

$15 CAD / jam
(375 Ulasan)

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 wit Lagi

$22 CAD / jam
(93 Ulasan)

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 / jam
(219 Ulasan)

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$20 CAD / jam
(117 Ulasan)

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 utilizat Lagi

$20 CAD / jam
(90 Ulasan)

phd in computer science having seven years of experience in Excel development and visual basics.

$25 CAD / jam
(47 Ulasan)

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lagi

$22 CAD / jam
(70 Ulasan)

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 / jam
(81 Ulasan)

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 / jam
(34 Ulasan)

Hi, I’m software and database developer with more than 35 years experience. The past 20 years I worked (full-time, in-situ) for two international organizations; IATTC, in San Diego, CA ,USA, and the Food and Agricultur Lagi

$38 CAD / jam
(8 Ulasan)

Let me review the spread sheet with data and your preferable format as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Lagi

$15 CAD / jam
(79 Ulasan)

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 avail Lagi

$16 CAD / jam
(50 Ulasan)

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 com Lagi

$22 CAD / jam
(29 Ulasan)

I am an Excel VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Lagi

$15 CAD / jam
(54 Ulasan)

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 las Lagi

$25 CAD / jam
(13 Ulasan)

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 Lagi

$15 CAD / jam
(4 Ulasan)

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 t Lagi

$15 CAD / jam
(16 Ulasan)

"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working her Lagi

$20 CAD / jam
(15 Ulasan)