Thread: [Solved] Accessing Visual Basic on my 2010 copy of Excel
View Single Post
 
Old 02-09-2016, 08:00 AM
justphilip justphilip is offline Windows 10 Office 2010 32bit
Novice
  
Join Date: Feb 2016
Posts: 5
justphilip is on a distinguished road
Default 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.
Reply With Quote