4 Messages
Digest #4413
Messages
Tue Oct 30, 2018 1:35 pm (PDT) . Posted by:
dha80026
I tried what you suggest (alt-F8) all i get is a new empty subroutine is created with this name. The next time I call this (from the macro page) it simply executes this empty subroutine. My stock prices are only updating at startup. Ideally I would sure like something I could call from VBA.
Tue Oct 30, 2018 2:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
After an alt+F8, You should be using the "Run" button, not the "Create"
button.
You can use it from VBA. You just have to add the add-in as a reference
library for your VBA project. Then everything in the add-in is available to
the VBA project.
Have you tried the option from the context menu, or adding the macro to a
button on your Quick Access Toolbar? I use buttons, so the macros are
always easily accessible.
On Tue, Oct 30, 2018 at 2:46 PM dha80026@... wrote:
>
> I tried what you suggest (alt-F8) all i get is a new empty subroutine is
> created with this name. The next time I call this (from the macro page) it
> simply executes this empty subroutine. My stock prices are only updating
> at startup. Ideally I would sure like something I could call from VBA.
>
>
button.
You can use it from VBA. You just have to add the add-in as a reference
library for your VBA project. Then everything in the add-in is available to
the VBA project.
Have you tried the option from the context menu, or adding the macro to a
button on your Quick Access Toolbar? I use buttons, so the macros are
always easily accessible.
On Tue, Oct 30, 2018 at 2:46 PM dha80026@... wrote:
>
> I tried what you suggest (alt-F8) all i get is a new empty subroutine is
> created with this name. The next time I call this (from the macro page) it
> simply executes this empty subroutine. My stock prices are only updating
> at startup. Ideally I would sure like something I could call from VBA.
>
>
Tue Oct 30, 2018 4:00 pm (PDT) . Posted by:
dha80026
Randy, Strangest thing, I was definitely pressing "Run" and not "Create" and it was creating. As luck would have it my PC just crashed, now pressing "Run" works. :)
I understand your interactive approach and will use it on my laptop. Unfortunately, I have another PC which is remote when I'm traveling (most of the time) on which I need to trigger the recalculation automatically. Any hints how to load or link the RCH code into my VBA program is appreciated.
I understand your interactive approach and will use it on my laptop. Unfortunately, I have another PC which is remote when I'm traveling (most of the time) on which I need to trigger the recalculation automatically. Any hints how to load or link the RCH code into my VBA program is appreciated.
Tue Oct 30, 2018 4:32 pm (PDT) . Posted by:
dha80026
Randy - I got it all figured out.
For others which may read this post in the future, you can add this to VBA by simply selecting Tools => References and then checking RCH_Stock_Market_Functions.
For others which may read this post in the future, you can add this to VBA by simply selecting Tools => References and then checking RCH_Stock_Market_
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar