Import data from xls file on the web

  • Thread starter Svilen Pachedzhiev
  • Start date
S

Svilen Pachedzhiev

Can anyone help me with guidelines how to import data from web based xls
file?
Is it possible to import sheet from such file and then update it
automatically?

Tahnks,

Svilen
 
R

Ron de Bruin

Hi Svilen

Do you want to update the file on the web directly
Do I understand you correct ?
 
S

Svilen Pachedzhiev

Hi Ron,

A few lines to make myself more clear:
There is a xls file in Internet with data. I want to import data or entire
sheet from this file into a xls file on my computer. So maybe the right
topic is "Import data from xls file FROM the web".

Regards,
Svilen


Hi Svilen

Do you want to update the file on the web directly
Do I understand you correct ?
 
S

Svilen Pachedzhiev

Thanks Ron! Direct links work now and it solves a part of my problem. But I
stell need to have some idea how to import data from xls file from web via
some kind of query.
Because with this method I can't control refreshment process, and I would
like to have such solution if I need to import csv or txt files.

Svilen
 
R

Ron de Bruin

Hi

Maybe you can use this ?
You can use this to copy a range from a file from a website (this is working, try it in a new workbook)

Maybe others have a better solution for you

Sub Getvalues()
ActiveWorkbook.Names.Add Name:="testing", _
RefersToR1C1:="='http://www.rondebruin.com/[Book2.xls]Sheet1'!R1C1:R10C4"

Application.ScreenUpdating = False
Range("A1:D10").Formula = "=testing"
MyWait 1
Range("A1:D10").Value = Range("A1:D10").Value
ActiveWorkbook.Names("testing").Delete
Application.ScreenUpdating = True
End Sub

Sub MyWait(PauseSeg As Double)
' Orlando Magalhães Filho
Dim Start
Start = Timer
Do While Timer < Start + PauseSeg
DoEvents
Loop
End Sub
 
R

Ron de Bruin

Hi Svilen

Strange, I get this private mail
Where have you post this question Svilen ?
Sorry, you are not authorized to post messages to this list
Reason ([email protected] is not a member of the list)
Subject: Re: Import data from xls file on the web
 
S

Svilen Pachedzhiev

I'm posting in my Outlook Express in
msnews.microsoft.com -> microsoft.public.excel
as a reply to your post.
I don't know why you have such mail?!?

Thanks for the solution, it works for xls files.

Svilen
 
S

Svilen Pachedzhiev

I've just received the same mail:

Sorry, you are not authorized to post messages to this list
Reason ([email protected] is not a member of the list)
Subject: Re: Import data from xls file on the web


Svilen
 
T

topola

Dank je Ron,
It works great now !
Following this path of thinking - can you suggest some way of getting
data from XML files.
Here is the example. Each day I get currencies exchange from the NBP -
National Bank of Poland.

Data tables can be reached:
http://www.nbp.pl/Kursy/TabArch.aspx?n=A235z051206
http://www.nbp.pl/Kursy/TabArch.aspx?n=A236z051207 and so on.

<tr valign="middle">
<td align="left" class="ar1">dolar amerykanski</td>
<td align="right" class="ar1">1&nbsp;USD</td>
<td align="right" class="ar1">3,2742</td>
</tr>

A236 dollar rate was 3.2742 PLN. How to get this?
Groetjes
 
T

topola

My previous information might have been misleading to you. The
document type is text/html - maybe that's why I can not open it in
Excel.

This is the file info:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-2">
<link rel="stylesheet" href="/css/kw.css" type="text/css">
<style type="text/css">

I looks like I should try to find a mechanism for searching withing
strings.
Groeten,
Topola
 
T

topola

OK, here is my questions - can I vlookup on a file on the Internet?
That would solve my problem. Thanks,
Topola
 
Top