4 Messages
Digest #3467
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
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
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.
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?
>
=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.
>
>
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.
>
> 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:
Posting Komentar