Doug Steele
dbdoug at gmail.com
Mon Jul 27 10:08:54 CDT 2009
I read or heard a podcast where Joel Spolsky (www.joelonsoftware.com), who wrote the specs for Excel VBA, commented on this. If I remember correctly, VBA had been set up by one of the groups (Excel or Access), and then the other group was forced to adapt VBA to work with its product - that's why the two object models are different. I can't find the exact reference, but here's his remarks on Mac vs Windows VBA for Excel: http://www.joelonsoftware.com/items/2007/04/25.html Doug Steele On Mon, Jul 27, 2009 at 7:35 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > LOL, it is entirely likely that they in fact never did collaborate at all. > > VBA is a base language. VBA for Access simply adds extensions required to > understand Jet and Access > specific things. VBA for Excel simply adds extensions to understand excel > specific things. What > the Access team would add to Excel's team when writing Excel extensions is > pretty questionable, and > vice versa. > >