Minggu, 24 Januari 2016

[smf_addin] Digest Number 3615

3 Messages

Digest #3615

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?

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?
>
>

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?

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar