Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string

Chiuso Pubblicato 5 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

I am looking for an excel tool where a user can input 10 values, it is converted to XML where it then calls an external website, the XML is pasted in a submitted, what is returned is a XML string which then is converted back in to Excel with highlight on specific values returned from the XML.

I have an example of this file that DOESN'T WORK. And I am looking for something which is simple, not so many inputs and outputs.

Very basic XML to be created.

<?xml version="1.0" encoding="UTF-8"?><INDATA version = "G"><SCENARIO_NAME>Basic Test Scenario</SCENARIO_NAME>

<INVOICE>

<CALCULATION_DIRECTION>F</CALCULATION_DIRECTION>

<COMPANY_ID>502</COMPANY_ID>

<COMPANY_NAME>Groupon-Deal Centre</COMPANY_NAME>

<COMPANY_ROLE>B</COMPANY_ROLE>

<CURRENCY_CODE>USD</CURRENCY_CODE>

<DOCUMENT_TYPE></DOCUMENT_TYPE>

<EXTERNAL_COMPANY_ID>1010</EXTERNAL_COMPANY_ID>

<INVOICE_DATE>2018-07-12</INVOICE_DATE>

<INVOICE_NUMBER>GGG Basic Test Scenario</INVOICE_NUMBER>

<IS_AUDITED>false</IS_AUDITED>

<IS_REPORTED>false</IS_REPORTED>

<IS_REVERSED>false</IS_REVERSED>

<POINT_OF_TITLE_TRANSFER>I</POINT_OF_TITLE_TRANSFER>

<SHIP_FROM>

<COUNTRY>GB</COUNTRY></SHIP_FROM>

<SHIP_TO>

<COUNTRY>GB</COUNTRY></SHIP_TO>

<TRANSACTION_TYPE>GS</TRANSACTION_TYPE>

<LINE ID="1">

<COMMODITY_CODE>9101.99.00</COMMODITY_CODE>

<GROSS_AMOUNT>1000</GROSS_AMOUNT>

<LINE_NUMBER>1</LINE_NUMBER>

<QUANTITIES><QUANTITY><AMOUNT>1</AMOUNT>

<UOM>each</UOM>

</QUANTITY>

</QUANTITIES>

</LINE>

</INVOICE>

</INDATA>

Excel Visual Basic XML

Rif. progetto: #17402880

Info sul progetto

27 proposte Progetto a distanza Attivo 5 anni fa

27 freelance hanno fatto un'offerta media di £404 per questo lavoro

asin1987

Dear Employer, I have read your job post and I will do the job for you. Please message me. Thanks and Regards, Ash

£555 GBP in 10 giorni
(182 valutazioni)
7.6
seaanddream

Hi, my name is Selim. I read your "Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string" project descriptions carefully before bidding. I checked the attached templ Altro

£300 GBP in 5 giorni
(282 valutazioni)
7.8
schoudhary1553

Hi there, Warm Greetings We came along with your request for Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string and we reviewed your project description. We'd Altro

£555 GBP in 10 giorni
(325 valutazioni)
7.9
dvcontact

Hi, After reading your project description about creating an Excel tool that will convert values into XML and collect data from external websites and then returns back as a convert Excel file, I feel like you have me Altro

£300 GBP in 10 giorni
(51 valutazioni)
6.4
sloker18

I am proficient with excel macro/VBA development, I can write the macro to exchange XML data with a URL, please kindly share the website info so I can have a better understanding of the scope of the work, if you are in Altro

£250 GBP in 3 giorni
(96 valutazioni)
6.1
archanaoswal

I know how to create xml file using Excel, submit the file to a website and parse the results. I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a sch Altro

£250 GBP in 3 giorni
(89 valutazioni)
6.0
SPARKtechBD

Good knowledge on conversion XML to CSV or Excel file. Basically I work on VB, VB.NET to build robust application. I am hard working freelancer and love to work for longterm basis and provide good support.

£750 GBP in 10 giorni
(11 valutazioni)
5.6
deepthi2889

Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (t Altro

£555 GBP in 3 giorni
(13 valutazioni)
5.2
supergana

Hi - I saw the file and the code behind it. I think a decent code has been written but its outdated. May be this was written sometime in early 2000s and never updated. Once its updated and compatibility brought in plac Altro

£498 GBP in 10 giorni
(26 valutazioni)
4.8
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Altro

£300 GBP in 5 giorni
(54 valutazioni)
4.7
pointlogic

Hello, I have read project details and i have good knowledge about it and can do it well. Please message me so we can discuss. Thank you/.

£500 GBP in 10 giorni
(5 valutazioni)
4.5
JustBoris

Hello. Your example is in the form of a VBA macro. I'm developing the same macros for more than eight years (samples are in my portfolio). I can solve your task without problems. Regards, Boris

£250 GBP in 10 giorni
(9 valutazioni)
4.0
letshappy

hello, i read the project and want to work on your project have more then 9 year experience in development

£366 GBP in 6 giorni
(4 valutazioni)
3.5
pinakincode

Hello sir, We have check detail and as per that you need tool for XML file convert into Excel file. we are able to do your work. Kindly revert back if you find our profile suitable for this project. Looking for Altro

£250 GBP in 3 giorni
(3 valutazioni)
2.9
marloufin

Hi, I've been in excel vba for 3 years and currently creating company tools for users reporting. Also I've been in xslt for 8 years currently creating data transformation using oxygen for source data like workday, Altro

£722 GBP in 10 giorni
(7 valutazioni)
4.2
mishelmilev92

Hello there and welcome to freelancer.com Yes I can do it and have done similar stuff before. so point is i should understand your needs and then i can do it. also i may be able to give you my ideas how to make it b Altro

£251 GBP in 7 giorni
(0 valutazioni)
0.0
ometaweb

Hello , Greetings of the Day!! We are very glad to inform you that we already had completed similar assignments. We are the team of 5+ Yrs Experienced Web designer and Developers located in the heart of India. Altro

£277 GBP in 10 giorni
(0 valutazioni)
0.0
shivamtr

Previously I worked on a similar kind of requirements where in a button is provided on the Excel sheet with name submit. It will take the values from Excel cells and does the required processing. Relevant Skills and E Altro

£333 GBP in 3 giorni
(0 valutazioni)
0.0
sachinhbti

I am having 10+ years of work experience in IBM iSeries RPG DB2. I am certified IBM DB2 database associate. worked with multiple large MNC's including CSC, HP, Fidelity & HSBC.

£555 GBP in 10 giorni
(0 valutazioni)
0.0