[smf_addin] Digest Number 1865

EXCEL Stock Market Functions Add-in

Messages In This Digest (2 Messages)

1a.

Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HSI-Ne From: boo1712

1b.

Re: Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HS From: Ron

View All Topics | Create New Topic

Messages

1a.

Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HSI-Ne

Posted by: "boo1712" boo1712@yahoo.co.uk   boo1712

Thu Jun 23, 2011 2:51 am (PDT)

Hi Guys,

Is there any function from smf that can be used to download tables from the following urls?
1. http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls

2. http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/con_17Jun11.csv

I tried using smfgetcsvfile but cannot display the table properly.

I also tried using

qurl = "http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls"

QueryQuote:
With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With

but also return error.

Please advise.

Thanks.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

1b.

Re: Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HS

Posted by: "Ron" ronaldj309@cox.net   ronaldj309

Thu Jun 23, 2011 3:09 am (PDT)

Why not just download it from the Web Browser? In Google Chrome, if I click on the "....xls" link it is downloaded into my Downloads folder and then I can open it in EXCEL.

--- In smf_addin@yahoogroups.com, "boo1712" <boo1712@...> wrote:
>
> Hi Guys,
>
> Is there any function from smf that can be used to download tables from the following urls?
> 1. http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls
>
> 2. http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/con_17Jun11.csv
>
> I tried using smfgetcsvfile but cannot display the table properly.
>
>
>
> I also tried using
>
> qurl = "http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls"
>
> QueryQuote:
> With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Range("a1"))
> .BackgroundQuery = True
> .TablesOnlyFromHTML = False
> .Refresh BackgroundQuery:=False
> .SaveData = True
> End With
>
> but also return error.
>
> Please advise.
>
> Thanks.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  98
  New Members
•  1
  New Files

Visit Your Group

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe