About
How this site is organized and what it's for
Weblog start pageThe start page contains the most recent 15 articles.
Home pageThe main home page of my website, not my weblog. Currently not used.
------------------
Articles by month
Click here to get all the articles for a particular month.
This month's articles (if any)
Current month
Today's articles (if any)
Articles dated 2008/12/01 only
------------------
Subtopics
------------------
Site map
- Root (1159)
- Asia (295)
- Cambodia (171)
- Augtrip (12)
- Khmer-language (57)
- Phrases01 (1)
- Miscellaneous (102)
- Japan (1)
- Language-misc (30)
- Miscellaneous (15)
- Thailand (68)
- Thai-language (22)
- Thingstobring (5)
- Clothes (1)
- Computer (1)
- Miscellaneous (3)
- Vietnam (5)
- 200603trip (2)
- Miscellaneous (2)
- language (1)
- Cambodia (171)
- Chrome (87)
- Computers (322)
- Health (14)
- Acclimatize (1)
- Miscellaneous (9)
- SARS (3)
- Links (15)
- Miscellaneous (113)
- Opinions (224)
- Drugs (3)
- Letters (8)
- Bangkokpost (2)
- IHT (2)
- Miscellaneous (1)
- Nation (3)
- Politics (149)
- Attack911 (42)
- Iraq (32)
- Miscellaneous (75)
- Society (57)
- Reviews (63)
- Spamproblem (1)
- Wi-fi (9)
- nolist (13)
- rcvd (3)
- Asia (295)
You may have to use search
if I move files around!
Listing of all articles by date
Flavours
There's more than one way to view this weblog; these links display the current page in other formats.
External links
These are a few of my favourite sites.
T E S T
Slashdot yesterday
Copyright © 2003-2007 Alternate Worlds Publishing, Boston MA USA
Wenhua dageming de zhongyao jiaoxun shi bixu fandui geren mixin
If I have been able to see further, it is because I am surrounded by midgets.
Never ascribe to stupidity that which can adequately be explained by malice.
"Your argument's repugnant and intriguing." "That's kinda my thing."
Danny's Weblog
2008 Jan 29 [ Tue ]Some books I've used for Excel VBA programming
Recently I've had to use Excel quite a lot. I used to be quite snooty about it (although I recognized that – after SQL Server – it was Microsoft's most respectable product). Now, having gotten into VBA programming, I have to admit you get a rather solid development environment.
Anyhow, I wanted to put in links to a couple of books I can recommend:
1. Excel 2007 VBA Programmming for Dummies - John Walkenbach
I actually read his version for Excel 2000 first. The two books are much the same. I had a feeling that he caught some errors in the new version, or maybe I just understood stuff more the second time through (I was unable to compare them except by memory).
I don't think Walkenbach ever did a version of this book for 2003. I don't think there was much difference between Excel 2000 and 2003, but there are a lot of changes in 2007 for the new menu ("commandbar") structure. And the 2007 book *only* documents the 2007 code - people expecting the book to be backwards-compatible with 2003 are going to be very disappointed.
But in general, I found the book quite ueseful.
Walkenbach recommends this "blog": [http://www.dailydoesofexcel.com/]
He also recommends reading Microsoft's own newsgroups via Google. Search Google Groups for microsoft.public.excel.programming, as well as several others under microsoft.public.excel.
2. The Absolute Beginner's Guide to VBA
The advantage of this book is it explains how to run multiple Office apps using VBA: for instance, to read your Outlook mailbox (or at least the header fields and a smidgen of the text) into Excel.
Also, it does show various useful examples in non-Excel apps, and I may need to take a shot at Word VBA sometime.
Incidentally, I rather wish the titles of these books weren't so embarrassing. Don't bring them to your client site! I've actually done some fairly complex stuff with Excel, and if clients ever see this blog they'll get the wrong idea. Hmm, then again if they see some of my other posts my goose is cooked anyhow!
Debug: hittotal: 23 startban: 0 dancookie: endbandate: banned: 0 tempdate: tert: jse: jsno jsh: 23