208802 Exchange Rate upload

In Progress

The current exchange rate upload into our system is a manual process and following steps are involved.

Step 1 - daily exchange rates are received via email

Step 2 - copy and paste the data into an upload template

Step 3 - Upload template into our system

We are keen to have an automatic upload of the information from the email into upload template therefore reducing the manual copy and paste function which may casue errors.

This template should also have the function to clear the previous/old data for each completed upload. This will therefore only require creation of one single template for each upload.

The following atatchements are included for refernce purposes.

1. Copy of daily email advice with exchange rates

2. Copy of the current upload template

3. Copy of the completed template for upload

The template can be either in Excel (xls) format and or Tab delimted (Txt) format.

Skills: Anything Goes, HTML, Visual Basic, XML

See more: rate visual basic, rate, data upload from excel, data exchange, xml tab, exchange data, xml excel format, xls visual basic, copy upload, upload xml, email rate, email xml format, upload daily, xls tab, exchange system, data xml xls, copy paste email template, automatic xml, template exchange, rate template, excel template data paste, paste xml, paste xls, excel email function, excel upload

Project ID: #1955027