Subu123
07-09-2013, 11:40 PM
Dear All
Hi. I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine
My problem is as follows : Some specific VBA are NOT working in XL 2010.... I am unable to figure out why ? details below
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%20Files/
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%20and%20Examples/
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 !!
1.6. these add ins collect data etc and are used in VBA within other files
2. My actual intention is to use the XL sheet here http://finance.groups.yahoo.com/group/TtP-S/files/%20TtP%20Excel%20Prototype%20/
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! (http://flic.kr/p/f5H8ey)
Screenshot - 08_07_2013 , 21_39_53 | Flickr - Photo Sharing! (http://flic.kr/p/f5H8dS)
Screenshot - 08_07_2013 , 21_40_26 | Flickr - Photo Sharing! (http://flic.kr/p/f5H8df)
Screenshot - 09_07_2013 , 11_54_04 | Flickr - Photo Sharing! (http://flic.kr/p/f6atMy)
Screenshot - 09_07_2013 , 11_54_27 | Flickr - Photo Sharing! (http://flic.kr/p/f6atLY)
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! (http://flic.kr/p/f6asGu) , its stopped at smfUpdateDownloadTable or as in sample here Screenshot - 08_07_2013 , 17_29_56_ver001 | Flickr - Photo Sharing! (http://flic.kr/p/f5hvkz) 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! (http://flic.kr/p/f6asFu)
2.11. THIS is my privacy setting Screenshot - 08_07_2013 , 17_40_26 | Flickr - Photo Sharing! (http://flic.kr/p/f5hJ16)
2.12. this is my security setting IN IE Screenshot - 08_07_2013 , 17_41_12 | Flickr - Photo Sharing! (http://flic.kr/p/f5hHXV)
2.13. this is my security setting in XL Screenshot - 09_07_2013 , 18_14_33 | Flickr - Photo Sharing! (http://flic.kr/p/f6hHqC)
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
Hi. I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine
My problem is as follows : Some specific VBA are NOT working in XL 2010.... I am unable to figure out why ? details below
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%20Files/
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%20and%20Examples/
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 !!
1.6. these add ins collect data etc and are used in VBA within other files
2. My actual intention is to use the XL sheet here http://finance.groups.yahoo.com/group/TtP-S/files/%20TtP%20Excel%20Prototype%20/
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! (http://flic.kr/p/f5H8ey)
Screenshot - 08_07_2013 , 21_39_53 | Flickr - Photo Sharing! (http://flic.kr/p/f5H8dS)
Screenshot - 08_07_2013 , 21_40_26 | Flickr - Photo Sharing! (http://flic.kr/p/f5H8df)
Screenshot - 09_07_2013 , 11_54_04 | Flickr - Photo Sharing! (http://flic.kr/p/f6atMy)
Screenshot - 09_07_2013 , 11_54_27 | Flickr - Photo Sharing! (http://flic.kr/p/f6atLY)
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! (http://flic.kr/p/f6asGu) , its stopped at smfUpdateDownloadTable or as in sample here Screenshot - 08_07_2013 , 17_29_56_ver001 | Flickr - Photo Sharing! (http://flic.kr/p/f5hvkz) 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! (http://flic.kr/p/f6asFu)
2.11. THIS is my privacy setting Screenshot - 08_07_2013 , 17_40_26 | Flickr - Photo Sharing! (http://flic.kr/p/f5hJ16)
2.12. this is my security setting IN IE Screenshot - 08_07_2013 , 17_41_12 | Flickr - Photo Sharing! (http://flic.kr/p/f5hHXV)
2.13. this is my security setting in XL Screenshot - 09_07_2013 , 18_14_33 | Flickr - Photo Sharing! (http://flic.kr/p/f6hHqC)
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