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".
---------------------------------------------------------------------
Thanks! I really hate it when it is such an easy answer.
thanks again
Richard A. Walker
Herley - Farmingdale
425 Smith Street
Farmingdale, N.Y. 11735-1198
Direct Voice: (631) 630-2086
Main Voice: (631) 630-2000 X286
Fax: (631) 630-2066
mailto: RWalker@GeneralMicrowave.com
-----Original Message-----
From: joel_dunsmore@agilent.com [mailto:joel_dunsmore@agilent.com]
Sent: Thursday, June 13, 2002 4:08 PM
To: Richard Walker; vrf@lvld.agilent.com
Subject: RE: PNA help
Hello Richard,
What's probably going on, is your S22 trace is on Channel 1. Change
all your "calc2" to "calc1".
PNA breaks the SCPI paridigm of 1-channel, 1-trace. You can have up to 16
traces on 1 channel (in four windows).
Traces don't care about windows when being read, only when being displayed.
So, we use the PAR:SEL to choose the trace.
As an alternative, might I suggest that you consider programming the PNA in
DCOM (Active X) over the LAN using VEE.
It is quite convenient, and works extremely well.
Joel
-----Original Message-----
From: RWalker@GeneralMicrowave.com [mailto:RWalker@GeneralMicrowave.com]
Sent: Thursday, June 13, 2002 4:14 AM
To: vrf@lvld.agilent.com
Subject: vrf: PNA help
Vee Users,
I am attempting to retreive trace data for four (4) traces
in window 1 (Channel 1). Below is the commands that I am sending to the PNA.
This set of commands only works for trace 1 not for the other three (3)
traces.
This set works
CALC1:PAR:SEL S11 "S11 is the trace name for trace 1"
CALC1":DATA? FDATA
This set does not work
CALC2:PAR:SEL S22 "S22 is the trace name for trace 2"
CALC2":DATA? FDATA
What am I doing wrong?
Richard A. Walker
Herley - Farmingdale
425 Smith Street
Farmingdale, N.Y. 11735-1198
Direct Voice: (631) 630-2086
Main Voice: (631) 630-2000 X286
Fax: (631) 630-2066
mailto: RWalker@GeneralMicrowave.com
---------------------------------------------------------------------
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 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".
---------------------------------------------------------------------