Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Thu Aug 20 14:53:27 CDT 2009
My vote is that the Excel team were not talking to the Access team on they day the came up with the Workbooks collection. -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Thursday, August 20, 2009 3:08 PM To: DBA Tech List Subject: [dba-Tech] Workbooks collection begins with 1 Most VBA collections begin with the index value of 0. I'm working with Excel's Workbooks collection, and Workbooks(0) returns an error. Any idea why this one's different? Maybe it's an Excel thing? I don't work much with VBA in Excel. Susan H. _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com