I gang

VBA to send XML to a server and update excel rows with response

This Job is to help and simplify a user issuing or adding value to a Gift-Card-Server via letting the user adding all the cards, names, values into an Excel sheet.

The Excel sheet would have 4 buttons on it at the top.

1- Issue Selected (This would send XML for each row in the Excel file that is selected with )

2- Issue To All

3- Reload Selected

4- Reload To All

When pressing the buttons the selected rows would be translated to XML and send to the server and then the response would be parsed to other columns and addeed to the rows.

All variables in the VBA should be variables and not hard coded (Server Address, Port, Location)

This excel file would be used as a template and should be able to be copied.

Include the word BlueMagic in your offer.

This should be a simple project for any one that knows VBA and dont bid above $100.00

Each Row is a seprate send to server

using INET API, InetConnect + InetSend + InetDataReady + InetRecvLine

-------------

<XML_FILE>

<REQUEST>

<CARDID>8551742002223090</CARDID>

<ACTION>ISSUE</ACTION> //This value depends on what button is pressed

<AMOUNT>250.00</AMOUNT>

<LOC>CDR</LOC> //This value is not one of the columns in the excel file and should be a variable in setup page

<USR>CINTHIA</USR>

<CTL>06292319</CTL>

<CLN>MYDONETION</CLN>

<TType>Gift</TType> //This value is not one of the columns in the excel file and should be a variable in setup page

</REQUEST>

</XML_FILE>

-----------------------

Response:

<?xml version="1.0" encoding="Windows-1252" standalone="no"?><XML_FILE><RESPONSE><CARDID>8551742002223090</CARDID><RESULT>APPROVED</RESULT><AUTH_CODE>[dac49ae2-98ec-9949-9c35-3549c6b78f55]</AUTH_CODE><AMOUNT>250.00</AMOUNT><BALANCE>250.00</BALANCE><ILOC>CDR</ILOC></RESPONSE></XML_FILE>

------

Reload Request:

<XML_FILE><REQUEST><CARDID>8551741001078844</CARDID><ACTION>RELOAD</ACTION><AMOUNT>300.00</AMOUNT><LOC>CDR</LOC><USR>DIANA</USR><TType>Gift</TType></REQUEST></XML_FILE>

Evner: Excel, Visual Basic for Apps, XML, Webservices

Se mere: excel vba open xml file, excel vba return xml data type, send xml post remote server php, excel vba generate xml, send xml server iphone, send xml request response php, send xml mobile server j2me, excel vba write xml document file, excel vba send skype message, send xml server php shipping price tnt, vba read xml file into excel

Om arbejdsgiveren:
( 88 bedømmelser ) Brooklyn, United States

Projekt ID: #21480676