There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Business Applications
Tag Cloud
audio blue blue screen boot bsod compaq computer cpu crash dell drivers dvd error excel firefox format freeze freezing hard drive install internet internet explorer kb951748 lan laptop loss of internet malware memory motherboard network networking outlook outlook 2007 problem restart screen security slow sound startup trojan update virus vista windows windows xp winxp wireless zonealarm zone alarm
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Vista problem downloading share price to excel


Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
05-Oct-2008, 07:28 PM #1
Solved: Vista problem downloading share price to excel
I have a spreasheet with a macro that enables collection of data from a source and also the latest share price through Yahoo. On home computer which uses XP Professional , with office 2003 ,it woks no problems at all. However, on my laptop with Vista home, and the same office 2003 ,when I run macro it collects the data but not the share price collection from Yahoo. Any thoughts on the reason. New to forum and trust this is in the right section Thanks Pedro
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
05-Oct-2008, 07:56 PM #2
update
Whilst I thought office 2003 would be just one version I have discovered that home computer using XP has Excel 2003 (11.6560.6568 )SP2 and the laptop which is the one that does not collect the share price has Excel 2003 (11.5612.5606) Could this be the problem Pedro
Zack Barresse's Avatar
Computer Specs
Distinguished Member with 3,549 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Oct-2008, 02:03 AM #3
Could be. Getting yahoo values has ALWAYS been tricky in Excel. If you're going to try that I would HIGHLY RECOMMEND you check out the SMF ADDIN Group (on Yahoo groups). There is an add-in created by R. Hammerlink, an invaluable tool if you want to use Yahoo and grab values from the net. Afaiac it's the only way to go.

Oh, and here is a link...

http://finance.groups.yahoo.com/grou...guid=326739896

HTH
__________________
___________
Regards, Zack (If you would like comments in any code, please say so.)

OfficeArticles.com :|: Extreme Excel Tutorial :|: Excel Articles by Ken Puls :|: Excel User Group, by Nick Hodge

What is a Microsoft MVP? :|: Live Tech Support? Click here
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
06-Oct-2008, 03:24 AM #4
Thanks for the link. I have posted my query there. Following discussions with the friend who compiled the macro he says the problem is that Vista is preventing Excel macro from creating a file styled"x.iqy" Pedro
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
07-Oct-2008, 07:36 PM #5
Zack, I downloaded that Add in you suggested and it is a very good tool to have for getting info from Yahoo on companies. Pedro
Zack Barresse's Avatar
Computer Specs
Distinguished Member with 3,549 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
07-Oct-2008, 07:44 PM #6
Yes, as far as I've seen it is the best tool for getting data from Yahoo [tickers]. Glad I could help point you to it.
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
07-Oct-2008, 08:32 PM #7
Zack, I wonder if there is a shortcut to refresh the data. I am only using live prices at this stage and need to retype the ticker code to refresh. Any suggestions Pedro
Zack Barresse's Avatar
Computer Specs
Distinguished Member with 3,549 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
08-Oct-2008, 01:50 AM #8
Your best route of information for that tool is the Yahoo group discussion board. You can subscribe to it and talk via email. I haven't used the add-in in quite a while, but I thought there was a refresh with it. You'll have to read the documentation or post to the yahoo group with a question. I don't have a solid answer for you on that.
__________________
___________
Regards, Zack (If you would like comments in any code, please say so.)

OfficeArticles.com :|: Extreme Excel Tutorial :|: Excel Articles by Ken Puls :|: Excel User Group, by Nick Hodge

What is a Microsoft MVP? :|: Live Tech Support? Click here
Pedro15's Avatar
Junior Member with 11 posts.
 
Join Date: Oct 2008
Experience: Intermediate
08-Oct-2008, 02:53 AM #9
Thanks anyway Zack Pedro
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 06:16 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.