Visual Basic

  • Thread starter Thread starter DDD
  • Start date Start date
D

DDD

There are a number of tasks my spreadsheet has to do that may be too complex
to use macros on its own.

I have little experience with using VB, (Only thing i have made is a web
browser program, (not linked to excel))
---------- ------------------ -----------------
------------------- ----
Does anyone know how i could learn (e.g. website etc) how to use visual
basic, not just to make programs but to also use it with excel?

How did you first learn to use it?
 
Check on Amazon.Com to see if they still have John Walkenbach's Excel VBA
Programming for Dummies on sale. I picked up a copy for about $17. It will
get you through the basics and then you can pick up other stuff from the web
and this site.
 
If you have Visual Basic version 6 (real VB, not VBA) at your
disposal, you can write a COM Add-In quite easily. See
http://www.cpearson.com/excel/CreatingCOMAddIn.aspx for details.
Writing an add-in in NET is much trickier (especially if you need to
support Office 2003 and Office 2007). For NET-based add-ins for
Office, I use the framework provided by Add-In Express
(www.add-in-express.com). It is a bit pricey, but it is much better
than Microsoft's model and well worth the cost if you're writing
commercial products (assuming you are familiar with VB.NET or C#).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top