importing wanted xml by link

dado6612

Well-known Member
Joined
Dec 4, 2009
Messages
591
I don't know much about xml, but I heard that by xml I can import data from web

Uhm.. what I want is someone who have time, wish and wiling to help me
I'll explain to him via PM
It's a little bit complicate, so I don't even know how to explain..

Arghh just ignore this thread, there is no hope for me :biggrin:
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

dado6612

Well-known Member
Joined
Dec 4, 2009
Messages
591
Thanks for your response
I didn't expect any answer so I'm late :biggrin:

I checked many pages and videos on youtube, but they all describe importing xml file

I will try to explain what am I seeking for

I have formula
H8=hyperlink(=HYPERLINK("http://api.erepublik.com/v2/feeds/market/" & G2 &"/"&G1&G8&G9&G10&G11)

ex of it http://api.erepublik.com/v2/feeds/market/1/39/10/20

what I want is import that data from link to excel

After that I need to filter it, cause i only need is price and amount, its first and second number of this example

This is only one usage of it

What I want in the end is this
http://api.erepublik.com/eapi-docs.pdf
some how make it working for all links from this pdf
its not problem make formulas to make links, just I don't know how to import those data from links

Maybe its needed one button, on which click data will be imported, cause, as I think, xml wont know when to import data from link

I think that no body wont understand me :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,132,873
Messages
5,655,737
Members
418,234
Latest member
jdorfma

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
Top