Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 02-09-2016, 09:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 02-15-2016, 08:54 AM
justphilip justphilip is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Feb 2016
Posts: 5
justphilip is on a distinguished road
Default 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
Reply With Quote
Reply

Tags
visual basic access

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 10:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft