AnsweredAssumed Answered

vrf Excel active X question.

Question asked by VRFuser on Jun 13, 2002

ExcelApp.Sheets("This_Sheet").Select;

Where "This_Sheet" is the literal name of the sheet that you wish to work
on...Of course, you could use a variable instead of the literal.

This should do it


Jeff Davis
Embedded Systems - CDI Technical Services
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435
http://www.cdicad.com

> -----Original Message-----
> From: Mark Goldberg [mailto:mgoldberg@sat-inc.com]
> Sent: Thursday, June 13, 2002 2:18 PM
> To: 'vrf@lvld.agilent.com'
> Subject: vrf Excel active X question.
>
>
> I am trying to fill in an excel spread sheet with multiple
> sheets. i.e. each
> sheet is a different frequency. The fill part is working
> except that the
> select sheet selects the new sheet but the data continues to
> fill on sheet1.
> Anyone know how to change the fill to the next sheet?
>
> 'ExcelApp.Sheets(b).Activate' - where (b) is the sheet name.
> It sets it
> active but still writes to the first sheet only.
>
> Thanks,
>
> MG
>
> ---------------------------------------------------------------------
> This is the "vrf" maillist, managed by Majordomo.  To send messages to
> this maillist, just email to "vrf@lvld.agilent.com". 
> Subscriptions and
> unsubscriptions are done through the address
> "vrf-request@lvld.agilent.com".
> If you need details, just send a message containing the text "help"
> to "vrf-request@lvld.agilent.com".
> ---------------------------------------------------------------------
>
> _____________________________________________________________________
> This message has been checked for all known viruses by UUNET
> delivered
> through the MessageLabs Virus Control Centre. For further
> information visit
> http://www.uk.uu.net/products/security/virus/
>

_____________________________________________________________________
This message has been checked for all known viruses by UUNET delivered
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------

Outcomes