xml import

dado6612

Well-known Member
Joined
Dec 4, 2009
Messages
591
Hi to all
this is my first question about this and till few moments ago i didn't even know something like this exist is excel :biggrin:

I'm trying to do next

In cell A1 is drop list
In cell A2 is drop list
In cells B3:B6 are specifications for product from list A2

I have formula in A7
=HYPERLINK("http://api.erepublik.com/v2/feeds/market/"&A1&"/"&A2&"/"&B3&"/"&B4&"/"&B5&"/"&B6)

what i want next is import data from that link to excel

ex. http://api.erepublik.com/v2/feeds/market/1/1/10/10

that data i wish to import

Maybe after user select and type desire description, he must press some import button and then data is imported

Don't know how better to explain, as I said this is my first time working with xml:cool:

thanks
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
lol
thanks
but i already start thread on that part of forum, and no response
i open it maybe 10 minutes after this one
 
Upvote 0

Forum statistics

Threads
1,225,516
Messages
6,185,440
Members
453,289
Latest member
ALPOINT_AIG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top