Stängt

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

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>

Kompetens: Excel, Programvaruarkitektur, VB.NET, Visual Basic, Visual Basics för apps

Visa mer: 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

Om arbetsgivaren:
( 0 omdömen ) Terrebonne, Canada

Projekt-id: #17725099

37 frilansare har i genomsnitt lagt bud på $20/timme för detta jobb

schoudhary1553

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 Mer

$20 CAD / timme
(299 omdömen)
7.7
Webxpert4u

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) Mer

$25 CAD / timme
(203 omdömen)
7.7
SBITServices

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

$15 CAD / timme
(375 omdömen)
7.3
zekovicm

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 Mer

$22 CAD / timme
(93 omdömen)
6.9
elqueabandona

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 / timme
(219 omdömen)
6.9
zebracaro

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

$20 CAD / timme
(117 omdömen)
6.6
archanaoswal

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 Mer

$20 CAD / timme
(90 omdömen)
5.9
usmanhassan123

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

$25 CAD / timme
(47 omdömen)
5.9
abhinovpankaj

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 Mer

$22 CAD / timme
(70 omdömen)
5.7
catstevens2009

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 / timme
(81 omdömen)
5.6
fedalal2

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 / timme
(34 omdömen)
5.6
MarcoAGarcia

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 Mer

$38 CAD / timme
(8 omdömen)
5.5
royalcalif

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

$15 CAD / timme
(79 omdömen)
5.7
sloker18

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 Mer

$16 CAD / timme
(50 omdömen)
5.1
jasalaz100

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 Mer

$22 CAD / timme
(29 omdömen)
4.8
aubrey03

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

$15 CAD / timme
(54 omdömen)
5.1
whitehorsetechn

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 Mer

$25 CAD / timme
(13 omdömen)
5.3
mmadi

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 Mer

$15 CAD / timme
(4 omdömen)
3.9
paulodayto08

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 Mer

$15 CAD / timme
(16 omdömen)
3.5
dataexplorer

"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 Mer

$20 CAD / timme
(15 omdömen)
3.4