why isn't VBA working in Excel 2010

[Subu]

Dear all gurus

Hi. I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine


My problem explained in Detail


1. I use add-ins from the stock market functions yahoo group : i.e. here : http://finance.groups.yahoo.com/group/smf_addin/files/Add-In Files/
1.1. the specific add-ins are the second links from the top called "...RCH_Stock_Market_Functions-2.1.2012.12.29.zip .."
1.2. These have been downloaded to my computer D:\drive and unzipped into d:\xyzdirectory\. D Drive is a fixed drive. Always gets the same drive letter.
1.3. To check IF these add ins work, I've downloaded templates / examples using the above libraries and checked. Templates can be found here http://finance.groups.yahoo.com/group/smf_addin/files/Templates and Examples/
1.4. the Templates I've tried work with minimal tinkering - i.e. changing the path to the XLA files
1.5. Uptill here is all OK !!


2. My actual intention is to use the XL sheet here http://finance.groups.yahoo.com/group/TtP-S/files/ TtP Excel Prototype /
2.1. Say the first file titled "... 01-TtP Portfolio Tracker.xlsm .."
2.2. I download this file save on my hard disk. again drive D. Fixed disk. always same letter
2.3. in this file, 01-TtP Portfolio....., I change the path to the XLA file called RCH_Stock_Market_Functions
2.3. I open "... 01-TtP Portfolio Tracker.xlsm .."
2.4. To check if the XLA is loaded then I hit Alt + F11, go to command prompt and see IF the RCH_Stock_Market_functions VBA is active / loaded
2.5. Screen shots of what I see
Screenshot - 08_07_2013 , 21_33_15 | Flickr - Photo Sharing!
Screenshot - 08_07_2013 , 21_39_53 | Flickr - Photo Sharing!
Screenshot - 08_07_2013 , 21_40_26 | Flickr - Photo Sharing!
Screenshot - 09_07_2013 , 11_54_04 | Flickr - Photo Sharing!
Screenshot - 09_07_2013 , 11_54_27 | Flickr - Photo Sharing!
Meaning I see all the sheets having the link
2.6. I see the RCH_Stock_Market_Functions loaded ... as far as I know other missing lib are NOT essential for this discussion
2.7. Then I try to compile the VBA in the sp sheet to check IF all the links are working i.e. sp sheet "... 01-TtP Portfolio Tracker.xlsm .."
2.8. I get a compile error as here Screenshot - 09_07_2013 , 11_57_05 | Flickr - Photo Sharing! , its stopped at smfUpdateDownloadTable or as in sample here Screenshot - 08_07_2013 , 17_29_56_ver001 | Flickr - Photo Sharing! which is at a similar VBA ... all these missing VBA are part of RCH_Update_Sstockc_market ......
2,8,1. so for some reason XL is NOT loading ALL the VBA
2.9 similar error IF I refresh the sheet (i/e.) run the VBA without compiling
2.10. samples here : Screenshot - 09_07_2013 , 12_07_58 | Flickr - Photo Sharing!
2.11. THIS is my privacy setting Screenshot - 08_07_2013 , 17_40_26 | Flickr - Photo Sharing!
2.12. this is my security setting IN IE Screenshot - 08_07_2013 , 17_41_12 | Flickr - Photo Sharing!
2.13. this is my security setting in XL Screenshot - 09_07_2013 , 18_14_33 | Flickr - Photo Sharing!




Could some one PLEASE help me with what is wrong ??


3.0. either the path is hard coded somewhere or
3.1. it is an XL version or something or
3.2. it is an internet setting / something like that or
3.3. it is a setting in XL that is killing me








thanks in advance
best regards


subu

 

[Andrew Poulsom]

What's the code for smfForceRecalculation? And what is the MISSING reference HoadleyOptions.xla?

 

[Subu]

What's the code for smfForceRecalculation? And what is the MISSING reference HoadleyOptions.xla?

thanks for the quick reply

1. code to smfForecceREcalculation

Public Sub smfForceRecalculation()
iMorningStar = 0
sAdvFNPrefix = ""
iInit = 0
For i1 = 1 To kPages
aData(i1, 1) = "" ' Reset stored ticker array
Next i1
If Val(Application.Version) < 10 Then
Application.CalculateFull
Else
Application.CalculateFullRebuild
End If
End Sub



2. the hoadly is a private lib and NOT used by me ...but that is NOT failing or NOT the one that is failing now


thanks and regards

subu

 

[Andrew Poulsom]

If it's missing you need to uncheck it.

 

[Subu]

If it's missing you need to uncheck it.

1. Hoadly's algorithm : NOT needed : Ok I will un check that

2. The other place "smfForecceREcalculation" is where it stalls : This VBA "smfForecceREcalculation" ...how do I load it ?

3. is the whole thing because the *.xla is an earlier version and I am using MS XL 2010 ?



regards

 

[Andrew Poulsom]

Is it still failing to compile after you have unchecked the missing reference?

 

[Subu]

Is it still failing to compile after you have unchecked the missing reference?

thanks a ton for your ideas.

Just now tried after un checking the hoadly library and it works !! i.e.file £ 1 works

I am trying the next few files and will revert should I need help


Thanks again
& best regards


Subu