[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