Office Page Guide -
- Excel Visual Basic for Applications
I have been using Excel through all versions since 2.0. (There was no version 1! I started with the one that came with a runtime version of Windows 2.0) I like VBA. Hope some of these code examples help you out.
Most of my work is in VBA or SQL right now
so some of the examples may be a little old. Recent projects have involved writing a query in Teradata and bpulling 95K rows into Excel VBA.
- Access VBA
About 90% of all my work is in Access or SQL now. Doing lots of applications where reports are created in Access then exported to Excel and remotely formatted.
Most of the Custom Functions I am building in one application will work in the other; simply change Recordsets to Cells.
- Word VBA
- It had been years since I had need to do anything with Word VBA. Most of my Word stuff is templates and mail-merge. Section added January 2015
- 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, EVER send attachments. I delete them immediately!
- Excel FAQ
Here are my most frequently asked questions.
- 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. If the links don’t work, let me know. If you are giving free (or mostly free) advice, I welcome your links.
- 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