|
|
Office Page Guide -
- Excel Visual Basic for Applications
- I have been using Excel through all versions since 2.0. I like VBA. Hope some of these code examples help you out. I have been beta testing Excel
2007 and think everyone is going to love it after they get past the menu changes (I
searched for undo for 20 minutes one night).
Most of my work is in VBA or SQL right now
so some of the examples may be a little old. Announcing: I am in the process of updating toys written in earlier versions to Office 2007. First order of business will be conversion of my Excel Utilities toolbar to Ribbon format. (11/14/2008)
- Access VBA
- I had to finally break down (2005) and learn Access VBA and though I have been tearing out a
lot of hair, it is pretty cool. Don’t tell anybody but sometimes I like Access better than Excel now. I will post a few examples while I am in the process of
converting the site to ASP.NET 2.0.
- Formulas and Functions
- Ever need that really strange formula but have no idea how
to write it? Check these out. I will try to help if you , but remember
I still have a full-time job and will not get to all questions. NEVER send attachments. I delete them immediately!
- Excel FAQ
- Here are my most frequently asked questions. I do not know the
answer to everything and will gladly tell you I don’t.
- Others that are doing great things with Office
- My Excel links page. Some of these are in languages that I
cannot read and are marked accordingly.
- Other Programs
- Within the last year, more and more of my work assignments have been in Access, Word and
Outlook. I am planning to add sections for these programs eventually.
- Got a Question?
- Do not attach examples! The demands on my time are preventing me from answering most questions at
this juncture.
|
|
