Jumat, 24 Juli 2015

[smf_addin] Digest Number 3467

4 Messages

Digest #3467
1.1
1.2
1.3
Re: RCHGetTableCell by "Randy Harmelink" rharmelink
1.4
Re: RCHGetTableCell by "Randy Harmelink" rharmelink

Messages

Thu Jul 23, 2015 2:52 am (PDT) . Posted by:

wongkayau

Hi Randy,

You are brilliant! It worked!

I also tried another table. It worked for most other tables in the website, except the below two:
http://www.pbc.gov.cn/publish/html/2015s03.htm
http://www.pbc.gov.cn/publish/html/2015s06.htm
Can you download the two?

Thank you very much.

Cheers,
Ka Yau

Thu Jul 23, 2015 5:35 am (PDT) . Posted by:

wongkayau

Hi Randy,

I finally got the last two tables done, by using your method. The steps are that I used a small macro to clear memory:

Sub ForceCal()
Application.Run "smfForceRecalculation"
End Sub


and then quit Excel. Then, I entered excel and use your method. It works finally.

Thank you so much for your help. Love your great addin tool, which has been tremendously helping me in last 2 years.

Have a good day!

Cheers,
Ka Yau



Thu Jul 23, 2015 8:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

These work for me:

=RCHGetTableCell("http://www.pbc.gov.cn/publish/html/2015s03.htm",1,"Total
Deposits<")

=RCHGetTableCell("http://www.pbc.gov.cn/publish/html/2015s06.htm",1,"Foreign
Assets<")

Note that there are TWO spaces between "Foreign" and "Assets".

On Thu, Jul 23, 2015 at 2:52 AM, wongkayau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> You are brilliant! It worked!
>
> I also tried another table. It worked for most other tables in the
> website, except the below two:
> http://www.pbc.gov.cn/publish/html/2015s03.htm
>
>
> http://www.pbc.gov.cn/publish/html/2015s06.htm
>
> Can you download the two?
>

Thu Jul 23, 2015 8:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You shouldn't need to run smfForceRecalculation if you are going to exit
and restart EXCEL. One or the other should be sufficient to purge the table
of saved web pages in the add-in.

On Thu, Jul 23, 2015 at 5:35 AM, wongkayau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I finally got the last two tables done, by using your method. The steps
> are that I used a small macro to clear memory:
>
> Sub ForceCal()
>
> Application.Run "smfForceRecalculation"
>
> End Sub
>
> and then quit Excel. Then, I entered excel and use your method. It works
> finally.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar