[AccessD] Excel Automation

Lawrence Mrazek lmrazek at lcm-res.com
Tue Oct 9 12:40:08 CDT 2007


Hi Rocky:

>From memory, I think it is something like:

    Set xlWs = xlWb.Worksheets(wrksheet)
    xlWs.Select 


Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
mobile: 314-496-1645

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, October 09, 2007 12:17 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Excel Automation

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





More information about the AccessD mailing list