Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Tue Oct 9 13:10:59 CDT 2007
IT WORKED! (You knew it would.) Thank you. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, October 09, 2007 10:50 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Excel Automation Hi Rocky That is, if wkb is your WorkBook: wkb.Worksheets(<name or index of worksheet>).Activate /gustav >>> rockysmolin at bchacc.com 09-10-2007 19:16 >>> Dear List: I am dealing with an excel workbook through automation and need to change the active worksheet using the worksheet name. I'm creating these worksheets on the fly taking the name from a data value in the Access app. But can't seem to get the syntax. Does anyone know this offhand? MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.5/1058 - Release Date: 10/8/2007 4:54 PM