By Stu on August 30th, 2010
I love developing functions, controls and business apps with Excel. I think Excel is one of the most revolutionary products for business in the last 30 years. So I am always using the developer tab. I skipped Excel/Office 2003 and in Excel/Office 2007 & 2010 you have to enable the developer tab.
I upgraded recently to Office 2010 and need to create a button in Excel and behold MS moved the developer check box. I almost cried (ok not really)…
A little bit of a search and you can find the instructions here (also tells you how to enable on Office 2010/2007) or just use my walk through.
By Stu on July 21st, 2010
Update: You can now see and purchase the 2010 NFL spreadsheet here.
As an update, I have been swamped over the last few weeks with my real job and that slowed down my testing of the 2010 NFL spreadsheet to a crawl (actually a dead stop). With the help of a new volunteer (thanks George), it looks like I am close to finishing the spreadsheet. So hopefully in the next week or so, it will be ready for purchase.
![Microsoft Excel - 2010NFLspreedsheet(v1.1-beta) [Compatibility Mode] Microsoft Excel - 2010NFLspreedsheet(v1.1-beta) [Compatibility Mode]](http://www.machinadei.com/grafx/2010NFLSpreadSheetInBeta_DD31/MicrosoftExcel2010NFLspreedsheetv1.1betaCompatibilityMode_thumb.png)
Update: You can now see and purchase the 2010 NFL spreadsheet here.
Last year I released an Excel spread sheet for the 2009 NFL season. It was downloaded 1013 times from September 2009 thru June 2010 (900 during the season). After releasing it I received a few requests to modify the spread sheet. So this year, I will release two version: 10 player and 20-40 player version (not finished yet). I will release the 2010 version around July after I finish testing it, writing up some documentation and making a screencast to teach users how to run the spread sheet. The spread sheet is to try and raise funds for a food pantry and maybe another charity (ASPCA?).
This is part II of what I’ve done to an Excel spread sheet programmatically…
A few weeks ago I posted how to hide and unhide Excel rows with VB.NET, so now lets help the user by creating a button and having it copy the range of information to be pasted in another document (email, Word, ect..).
This is a really short post because the code is so simple.
First, make a button on the excel page.
Second, use this code to copy a range.
Code Snippet
- Private Sub copyButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles copyButton.Click
This is a preview of
Programmatically Copy Excel Range with VB.NET
.
Read the full post (155 words, estimated 37 secs reading time)