Tuesday, November 9, 2010

Excel 2007 Tutorials

I'll be putting up some Excel 2007 and Excel 2010 tutorials shortly but if you want to learn more about Excel, you have to buy Learn Excel 2007 from Mr Excel. Buy it now.

Learn Excel 97 Throught Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved

Review of Brandon Connell Make Money Blogging

I've recently jumped into researching how to make money online and Make Money Blogging and I came across the blog of Brandon Connell. He's just started a new competition called a blog duel where he competes with another blogger to beat some purpose. In this case, he's trying to rank his website higher in Google and other search engine searches for the the phrase "Make Money Blogging".

One of the really interesting techniques he's used is to create a simple web template called Ghostly Acres. It is a nice little template, and he included a Photoshop format (.psd) file with the graphics as well as the font used to create the logo so you can edit it for your own purposes.

His technique was simply to ensure that the footer link that goes directly to his make money site stays intact. Sounds like a great idea! Help the guy out and use his template for a little grunge texture fun!

If you are interested in blogging and making money buy doing so, check out the ProBlogger book by Darren Rowse and Chris Garrett.

Thursday, June 17, 2010

VBA Reference Books

Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

I just received an email stating that John Walkenbach's new book, John Walkenbach's Favorite Excel 2010 Tips and Tricks, has been released and will soon be available. You can purchase it now (I've provided links below to help you out, click on the orange book.

I've been a fan of Mr. Spreadsheet for the last couple of years, and I found his book, Excel 2007 Power Programming with VBA (the purple book) to be an indispensible resource. He has a witty, non-stuffy style of writing, all his code is well commented and it contains many useful, real-world examples as well as providing technical inside for those who want to know more. Nothing is more annoying than an author with a business background who tries to write computer material, but John Walkenbach really enjoys using Excel and it shows in his writing.

Luckily, with Office 2010 just released Tuesday, Walkenbach also has his Excel 2010 Power Programming availalble. While some of his material is unchanged between versions, its still amazing how much the guy can write.

Friday, February 5, 2010

Learn VBA with VBA Tutorials

Hi everyone!

I'm a computer instructor who also does quite a bit of blogging, so I decided I would start a blog related to some of the things I do in my job. I have a problem posting to my blogs regularly, but maybe this will be away for me to keep posting new things as I learn them.

Starting in January 2010 I have been lecturing a university level course in programming in Visual Basic for Applications, or VBA. I've been programming VB and VBA now for 3 years, and will now focus only on VBA.

I'll use this blog to provide links, resources, samples, and tutorials for programming Microsoft Office in VBA.

Starting Monday, I've been working with the beta for Office 2010 and trying to keep up to date with the recent changes. On the outside, there are no major changes. The VBE is unchanged, but under the hood there are a few surprises. Here are a few good links I've found so far:


New VBA7 engine: http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx


Changes to the Excel 2010 Object Model: http://msdn.microsoft.com/en-us/library/ee836187(office.14).aspx

But just today I've noticed something. In Office 2007 you can get to the Visual Basic Editor (VBE) very quickly by pressing ALT-F11 (try it and see what happens!). This works in Word, Excel, Access and PowerPoint... and I think Publisher.

Now, in Excel 2010 (Beta), Alt-F11 will open the VBE. It does not work in Word though! As I get around to it, I'll be trying out other things and posting my findings here.

In similar news, I've been asked to put together a computer science curriculuum that will be taught at a summer day camp for kids. I'm considering teaching programming concepts in VBA. Please let me know if you have ever done something similar or know someone who does.

All the best, and if there is something you want to see or learn, let me know!