3 Messages
Digest #3615
1.2
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
Messages
Sat Jan 23, 2016 7:58 pm (PST) . Posted by:
"joo zhi" perseuslim11
I see, so if I were to save the excel file, then close it and reopen the saved excel file, it would also force the link to retrieve updated information from the website?
Sent from Yahoo Mail on Android
On Sun, 24 Jan, 2016 at 11:45, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
It would be stuck at 3.88.
You would need to use smfForceRecalculation macro to force the add-in to get a fresh copy of all web pages.
Exiting and restarting EXCEL would accomplish the same thing.
That's because the add-in saves a copy of a web page before extracting data from it. If you do a normal recalculation, it would just redo the extract from the same saved copy of the web page.
smfForceRecalculation purges all saved copies of web pages, so the functions need to get a new copy.
On Sat, Jan 23, 2016 at 8:35 PM, perseuslim11@... wrote:
btw, one question, will the number 3.88 be autoupdated to a new value if the website value changes to say, 4.21?or will it be stuck at 3.88?
Sent from Yahoo Mail on Android
On Sun, 24 Jan, 2016 at 11:45, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
It would be stuck at 3.88.
You would need to use smfForceRecalculati
Exiting and restarting EXCEL would accomplish the same thing.
That's because the add-in saves a copy of a web page before extracting data from it. If you do a normal recalculation, it would just redo the extract from the same saved copy of the web page.
smfForceRecalculati
On Sat, Jan 23, 2016 at 8:35 PM, perseuslim11@
btw, one question, will the number 3.88 be autoupdated to a new value if the website value changes to say, 4.21?or will it be stuck at 3.88?
Sat Jan 23, 2016 10:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No. Not just the file, but the program. The VBA environment still stays
intact if all you do is close a workbook without exiting EXCEL altogether.
On Sat, Jan 23, 2016 at 8:58 PM, joo zhi perseuslim11@... wrote:
>
> I see, so if I were to save the excel file, then close it and reopen the
> saved excel file, it would also force the link to retrieve updated
> information from the website?
>
>
intact if all you do is close a workbook without exiting EXCEL altogether.
On Sat, Jan 23, 2016 at 8:58 PM, joo zhi perseuslim11@
>
> I see, so if I were to save the excel file, then close it and reopen the
> saved excel file, it would also force the link to retrieve updated
> information from the website?
>
>
Sat Jan 23, 2016 10:50 pm (PST) . Posted by:
"joo zhi" perseuslim11
Ok, understood, thanks Randy, for your clarification and guide ^^
Sent from Yahoo Mail on Android
On Sun, 24 Jan, 2016 at 14:37, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
No. Not just the file, but the program. The VBA environment still stays intact if all you do is close a workbook without exiting EXCEL altogether.
On Sat, Jan 23, 2016 at 8:58 PM, joo zhi perseuslim11@... wrote:
I see, so if I were to save the excel file, then close it and reopen the saved excel file, it would also force the link to retrieve updated information from the website?
Sent from Yahoo Mail on Android
On Sun, 24 Jan, 2016 at 14:37, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
No. Not just the file, but the program. The VBA environment still stays intact if all you do is close a workbook without exiting EXCEL altogether.
On Sat, Jan 23, 2016 at 8:58 PM, joo zhi perseuslim11@
I see, so if I were to save the excel file, then close it and reopen the saved excel file, it would also force the link to retrieve updated information from the website?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar