Closed

VBA 'Macro' for an application

We have begun using some new order management software which can be found here:

[url removed, login to view] for downloading the orders from our website.

In the different 'Views' you can display different order fields such as customer name, item ordered, value of order etc.

There is the option in the software to create a custom View, and you can add custom fields to customer orders. These can be easily written out as a macro in the software.

E.g. if the grand total of the customer's order is 10.00 including tax which displays in the 'Grand total' field, then I could create a new field called 'tax calculator' and in it insert the macro:

[%Grand total%] [*] 0.20

this would give me the value in the field as 2.00 which is the amount of tax (at 20%) in the order

I have been told that the style of scripting is VBA although I think you may also be able to use XML instead (there is a mention of this in the helpfile) - I am unsure of this.

I have spent some time trying to familiarise myself with the software and macros to be able to write my own, more complicated macros, and have contacted the software developer for help but it is taking me too long so really I need a freelancer to help learn the macro part of this software to write so more advanced macros for me and then explain what I was doing wrong :-)

For example I would like a macro which will decide which postage service to display, based on the price of the item. It will then output this delivery service name instead of the delivery service that the customer selected, if it is a better service.

I have so far worked out how to base a delivery service on the value of the item but have not completed the macro:

[%Order Total%][][=]39[DELIVERYSERVICE1][DELIVERYSERVICE2]][DELIVERYSERVICE3]

----

I need a freelancer to spend time understanding the software, understanding the macro coding, and be able to create new macros for me for the software depending on my requirements. I would expect there to be 7+ Hours work required. Please bid based on your hourly rate.

----

Attachments: Screenshot of the section of the application to work on,

chm Help File from the application with all explanations

[url removed, login to view] shows part of the helpfile which explains basic macro coding.

----

Bidder must regularly use ** SKYPE ** for contact

Bider must have good familiarity with written English for communicating

Bidder must be online for at 4hrs or more during Mon-Fri GMT 09:30-18:00

Bidder must be familiar with TeamViewer for remote access to my system

Skills: Anything Goes, Software Architecture, Software Testing, Visual Basic, XML

See more: write my name in style, work base for freelancer, work as freelancer remote, work as a software developer as a freelancer, work as an online freelancer, work as a coding freelancer, what's wrong with my website, view xml online, views for freelancer, vba access developer, value or freelancer com, total for freelancer, teamviewer.com, system requirements for freelancer, software developer remote, software developer is it for me, software developer freelancer website, software developer at freelancer, scripting freelancer, screenshot online website, please help me write an application, online visual basic help, online visual basic coding, online tax freelancer, online help with visual basic

About the Employer:
( 29 reviews ) Leatherhead, United Kingdom

Project ID: #4303970

4 freelancers are bidding on average $9/hour for this job

JackBradford

Hello, My name is Jack Bradford and I have over 10 years of Excel design, MACROS and VBA experience. I am willing to learn what you are trying to do and I can implement an automated solution. Let me know if I More

$14 USD / hour
(3 Reviews)
2.8
soneekajaiswal81

Hi, I'm a software test engineer with 7 years of experience in very renowned companies. I'm basically an automation test engineer writing scripts using VB scripting and/or VBA (excel macros). I'm confident that I More

$8 USD / hour
(1 Review)
2.1
yogesh017121712

Hi, I would like to take over this macro.

$5 USD / hour
(0 Reviews)
0.0
warishj

See my profile I have got the expertise in it

$6 USD / hour
(0 Reviews)
0.0
fahmidaward

I can start now. Please read your private email.

$8 USD / hour
(0 Reviews)
0.0