5 Messages
Digest #4412
Messages
Mon Oct 29, 2018 11:07 am (PDT) . Posted by:
timdbui
Hi Randy,
Could you please show me how to force refresh the template so that I can get the latest price when I refresh the page?
Thanks, Tim
Could you please show me how to force refresh the template so that I can get the latest price when I refresh the page?
Thanks, Tim
Mon Oct 29, 2018 11:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just run the smfForceRecalculation macro. I have it on a button on my Quick
Access Toolbar, but it should also be available on the context menu within
EXCEL.
On Mon, Oct 29, 2018 at 11:07 AM timdbui@... wrote:
> Could you please show me how to force refresh the template so that I can
> get the latest price when I refresh the page?
>
>
>
Access Toolbar, but it should also be available on the context menu within
EXCEL.
On Mon, Oct 29, 2018 at 11:07 AM timdbui@... wrote:
> Could you please show me how to force refresh the template so that I can
> get the latest price when I refresh the page?
>
>
>
Mon Oct 29, 2018 12:20 pm (PDT) . Posted by:
timdbui
I figured it out, Randy. Right click, SMF, and Recalc Worksheet.
Thank you!
Thank you!
Tue Oct 30, 2018 1:46 am (PDT) . Posted by:
dha80026
Randy,
I have the same question. I have hunted all over including a search of the Object Browser and I can't find SMFFourceRecalculation. anywhere. There are lots of SMF commands in the completion pulldown but not this one. When I try to call it in VBA I get "Sub not defined" when I run the Macro. The version I have installed is "Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (64-bit) NT 6.01; 16.0; www; Local; 1)"
Any hints really appreciated.
Dave
I have the same question. I have hunted all over including a search of the Object Browser and I can't find SMFFourceRecalculat
Any hints really appreciated.
Dave
Tue Oct 30, 2018 2:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You wouldn't find it in VBA unless you set up the add-in as a reference
library for the VBA project.
I'm not sure which pull-down you're referring to...you mean for functions?
This is a macro, not a function.
You should be able to do it manually with the macro dialog. Alt-F8 to open
it up, then you need to type in the macro name. It doesn't list it because
the dialog only lists macros from open workbooks.
On Tue, Oct 30, 2018 at 2:13 AM dha80026@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I have the same question. I have hunted all over including a search of
> the Object Browser and I can't find SMFFourceRecalculation. anywhere.
> There are lots of SMF commands in the completion pulldown but not this
> one. When I try to call it in VBA I get "Sub not defined" when I run the
> Macro. The version I have installed is "Stock Market Functions add-in,
> Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (64-bit) NT 6.01; 16.0; www;
> Local; 1)"
>
> Any hints really appreciated.
>
>
library for the VBA project.
I'm not sure which pull-down you're referring to...you mean for functions?
This is a macro, not a function.
You should be able to do it manually with the macro dialog. Alt-F8 to open
it up, then you need to type in the macro name. It doesn't list it because
the dialog only lists macros from open workbooks.
On Tue, Oct 30, 2018 at 2:13 AM dha80026@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I have the same question. I have hunted all over including a search of
> the Object Browser and I can't find SMFFourceRecalculat
> There are lots of SMF commands in the completion pulldown but not this
> one. When I try to call it in VBA I get "Sub not defined" when I run the
> Macro. The version I have installed is "Stock Market Functions add-in,
> Version 2.1.2018.01.
> Local; 1)"
>
> Any hints really appreciated.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar