Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Dynamic Hyperlinks, Retrieving tables also from web into EXCEL 2010

05 May 2011   #1

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 
Dynamic Hyperlinks, Retrieving tables also from web into EXCEL 2010

Hi all
I spent a bit of time trying to pull stuff off YAHOO for Financial analysis.

I've uploaded the spreadsheet ( the RAR file)so you can use some of the techniques for other stuff -- doesn't matter if you don't understand the Stock exchange -- should give you a basic idea of

1) Pulling a TABLE from YAHOO as a CSV file and loading it to EXCEL cells
2) Creating Dynamic Hyperlinks for linking to specified web pages

I'm sure the VBA gurus could make my code more efficient -- I'm NOT a programming Guru -- so if there are any better ways just do it .

I actually had a lot of fun with this stuff.

For Call / Put data enter the symbol in Cell K7 and fill in cells K9 -K15 then click Call / put buttons

To see option detalis click link in Cells N7 / O7

You don't need to be a Stock Guru -- the spreadsheet just shows what you can do with WEB DATA -- plenty of other applications I'm sure.


Screen shot enc of the basic spreadsheet

Have fun with it

To see macros etc just hit ALT / F11 from the excel main sheet or enable the developer view and click on macros



Cheers

jimbo




Attached Thumbnails
Dynamic Hyperlinks, Retrieving tables also from web into EXCEL 2010-stok.png  
Attached Files
File Type: rar quotes_v5a.rar (83.0 KB, 4 views)
My System SpecsSystem Spec
.

Reply

 Dynamic Hyperlinks, Retrieving tables also from web into EXCEL 2010




Thread Tools



Similar help and support threads for2: Dynamic Hyperlinks, Retrieving tables also from web into EXCEL 2010
Thread Forum
Hyperlinks not working in outlook 2010 Microsoft Office
Solved Outlook 2010 E-mail Hyperlinks Not Working Microsoft Office
Solved Outlook 2010 - URLs no longer display as hyperlinks when reading mail Microsoft Office
Solved Automatically update hyperlinks in PPT 2010 when changing file path Microsoft Office
Microsoft Outlook 2010 and Hyperlinks Browsers & Mail
Formatting Excel 2010, Excel 2003 Microsoft Office
Outlook 2010 hyperlinks in email "cold" Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 11:42 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33