#1
|
|||
|
|||
Accessing Visual Basic on my 2010 copy of Excel
I would like to know if Visual Basic can be accessed in my 2010 Excel. Is it an add on feature? My Excel does not have the navigation path described in instructions below. How do I get there? TIA JP
Source: http://www.spreadsheetml.com/finance...ckquotes.shtml In Microsoft Excel 2007/2010/2013: Go to Developer->Visual Basic 2. Right click on VBAProject (your Excel Filename) and select Insert->Module. A default Module1 will be inserted. Click on Module1 and paste the VBA code below on the right hand side of the Visual Basic Editor. The following VBA code allows you to download data from Yahoo Finance using a specified Stock symbol, Start Date and End Date. |
#2
|
||||
|
||||
Hi
right-click the empty part of a ribbon Select Customize the ribbon In the main Tabs section check the Developer tab A new tab is now added with all you need Hitting Alt+F11 should also open the editor
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Debuging Visual Basic within Excel usage
I was able to activate visual basic on my Excel ribbon but I ran into a code error - old coding example and apparent change in MSN format. Is there a debug feature that I can use? My coding background is dated but I was very good at it when active - 14 special languages. TIA JP
|
Tags |
visual basic access |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to break Links to FIles in visual basic? | Asinkan | PowerPoint | 0 | 11-15-2012 03:08 AM |
Excel 2010 Visual Basic design/coding | charlesmac | Excel Programming | 2 | 08-10-2012 01:13 AM |
Visual Basic Editor changes from 2003 to 2007 | Rockitman31 | Word VBA | 4 | 09-21-2011 12:01 PM |
Referencing Tables in Visual Basic Editor | DavidB | Word Tables | 0 | 09-21-2009 04:01 PM |
A little Visual Basic Help Please | leroytrolley | Excel | 4 | 08-22-2008 03:57 AM |