Closed

VBA 'Macro' for an application

This project received 5 bids from talented freelancers with an average bid price of $8 USD / hour.

Get free quotes for a project like this
Employer working
Project Budget
$2 - $8 USD / hour
Total Bids
5
Project Description

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 [url removed, login to view] 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%] [*] [url removed, login to view]
this would give me the value in the field as [url removed, login to view] 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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online