importing wanted xml by link

dado6612

Well-known Member
Joined
Dec 4, 2009
Messages
590
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:
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

dado6612

Well-known Member
Joined
Dec 4, 2009
Messages
590
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:
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,160
Messages
5,509,511
Members
408,738
Latest member
mkarhoff

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top