Sabtu, 27 September 2014

[smf_addin] Digest Number 3191

3 Messages

Digest #3191

Messages

Fri Sep 26, 2014 6:40 am (PDT) . Posted by:

"Brad Reel" reeldeal9090

Since I was seeing the XLA in my project window, I actually had no idea I
needed to do anything to reference it (back to my point about knowing
enough to be dangerous). I found this site:

http://www.fontstuff.com/vba/vbatut08.htm

Which explained about needing to do the following in VBA:

Menu --> Tools --> References

Form there I got a menu of items that could be checked and unchecked.
RCH_Stock_Market_Functions
was unchecked. Once I checked it and ran my code again all is well.

I realize that you probably know all that Randy, just documenting it so
hopefully I can save someone else some pain somewhere down the road. :-)

BTW, while I loved using your Add in directly in Excel, this is going to be
friggin' awesome via VBA! So much more capability to automate my routine.
Thanks for putting this together.

On Thu, Sep 25, 2014 at 11:32 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> I would suspect that you haven't set up the add-in as a reference library
> for the VBA project.
>
>
> On Thu, Sep 25, 2014 at 8:59 PM, brad.reel90@... wrote:
>
>> Hi Randy. I've tried until I am blue in the face to figure out what I
>> am doing wrong here. Part of the problem is I know enough VBA to be
>> dangerous.
>>
>> I found this topic 5308 on what I am trying to.
>>
>> EXCEL Stock Market Functions Add-in
>> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/5308>
>> [image: image]
>> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/5308>
>> EXCEL Stock Market Functions Add-in
>> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/5308>
>> This group is the home base for the Stock Market Functions add-in
>> developed by Randy Harmelink. This add-in contains a number of user defined
>> functions for ...
>> View on groups.yahoo.com
>> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/5308>
>> Preview by Yahoo
>>
>>
>> Based on that I tried the brute force method as follows:
>>
>>
>> Sub Test()
>>
>>
>> Sheets("Sheet1").Select
>>
>> Range("A1:E1000") =
>> RCH_Stock_Market_Functions.RCHGetYahooHistory("AEE", 2012, 4, 20, 2014, 9,
>> 25, "d", "DOHLC", 1, 0, 1, 1000, 5)
>>
>>
>> End Sub
>>
>>
>> When I execute this, I get a Run-time error '424":
>>
>> Object Required
>>
>>
>> When I as below (without the "RCH_Stock_Market_Functions.") I get:
>>
>>
>> Compile Error Sub or Function not Defined
>>
>>
>> Sub Test()
>>
>>
>> Sheets("Sheet1").Select
>>
>> Range("A1:E1000") = RCHGetYahooHistory("AEE", 2012, 4, 20, 2014, 9,
>> 25, "d", "DOHLC", 1, 0, 1, 1000, 5)
>>
>>
>> End Sub
>>
>>
>> I've also flip-flopped the dates as I wasn't certain what was start date
>> / end date. That didn't make a difference.
>>
>>
>> I know the module I am calling from is in 1 project, your Function is in
>> the add in. I think that has something to do with it, but can't see where
>> that caused anyone else issues. I'm stuck. Whatever help you can provide
>> is appreciated. Let me know what other info you need.
>>
>
>
>

Fri Sep 26, 2014 7:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Already documented. :)

This item is on the "Tips and FAQs" web page:

Link
<https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/708>9.2
- Tip: Using SMF functions in VBA modules
Item #5 on that linked message is:

"Use menu option > Tools > References and check the box in front of the
"RCH_Stock_Market_Functions" reference library."

On Fri, Sep 26, 2014 at 6:40 AM, Brad Reel brad.reel90@... wrote:

>
> Since I was seeing the XLA in my project window, I actually had no idea I
> needed to do anything to reference it (back to my point about knowing
> enough to be dangerous). I found this site:
>
> http://www.fontstuff.com/vba/vbatut08.htm
>
> Which explained about needing to do the following in VBA:
>
> Menu --> Tools --> References
>
> Form there I got a menu of items that could be checked and unchecked. RCH_Stock_Market_Functions
> was unchecked. Once I checked it and ran my code again all is well.
>
> I realize that you probably know all that Randy, just documenting it so
> hopefully I can save someone else some pain somewhere down the road. :-)
>
> BTW, while I loved using your Add in directly in Excel, this is going to
> be friggin' awesome via VBA! So much more capability to automate my
> routine. Thanks for putting this together.
>

Fri Sep 26, 2014 8:17 am (PDT) . Posted by:

"Brad Reel" reeldeal9090

Gawd dangit! I was too tired last night. Honestly, I was about to hit
your site and look for something, but it was time to go to bed.

Thanks again, Randy.

On Fri, Sep 26, 2014 at 9:54 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Already documented. :)
>
> This item is on the "Tips and FAQs" web page:
>
> Link
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/708>9.2
> - Tip: Using SMF functions in VBA modules
> Item #5 on that linked message is:
>
> "Use menu option > Tools > References and check the box in front of the
> "RCH_Stock_Market_Functions" reference library."
>
> On Fri, Sep 26, 2014 at 6:40 AM, Brad Reel brad.reel90@... wrote:
>
>>
>> Since I was seeing the XLA in my project window, I actually had no idea I
>> needed to do anything to reference it (back to my point about knowing
>> enough to be dangerous). I found this site:
>>
>> http://www.fontstuff.com/vba/vbatut08.htm
>>
>> Which explained about needing to do the following in VBA:
>>
>> Menu --> Tools --> References
>>
>> Form there I got a menu of items that could be checked and unchecked. RCH_Stock_Market_Functions
>> was unchecked. Once I checked it and ran my code again all is well.
>>
>> I realize that you probably know all that Randy, just documenting it so
>> hopefully I can save someone else some pain somewhere down the road. :-)
>>
>> BTW, while I loved using your Add in directly in Excel, this is going to
>> be friggin' awesome via VBA! So much more capability to automate my
>> routine. Thanks for putting this together.
>>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar