AnsweredAssumed Answered

vrf Copying sheet values

Question asked by VRFuser on Apr 4, 2002
If you are using Office 97, then the help files for ms word and ms excel are
"vbawrd8.hlp" and "vbaxl8.hlp" respectively.

Rahul Bheemidi
Agilent Technologies



-----Original Message-----
From: Wills, Mark [mailto:MWills@tycoelectronics.com]
Sent: Thursday, April 04, 2002 4:09 AM
To: 'Rolf.Neumann@infineon.com'
Cc: vrf@lvld.agilent.com
Subject: RE: vrf Copying sheet values


Many thanks Rolf, this is just what I needed.

I did also ask before whether anybody knew how to get the help to work
correctly when selecting active-X functions from the
Device > Function & Object Browser. All that I seem to get is "There is no
help topic for (selected member etc)"

Are some additional Office help files required to be installed or something
?

Regards,
Mark Wills

Principal ATE Engineer
Wireless Automotive System Group

> * E-mail:  mwills@tycoelectronics.com
> * Phone: +44 (0)1908 574209 (direct line)
> * Phone: +44 (0)1908 574200 (switchboard)
> *  Fax:     +44 (0)1908 574300
>
Tyco Electronics UK Limited  M/A-COM Division
Featherstone Road
Wolverton Mill
Milton Keynes
MK12 5EW

Creating chaos out of order !


-----Original Message-----
From: Rolf.Neumann@infineon.com [mailto:Rolf.Neumann@infineon.com]
Sent: 04 April 2002 11:58
To: Wills, Mark
Cc: vrf@lvld.agilent.com
Subject: AW: vrf Copying sheet values


Hi Mark,
find attached a (very)short example of copying values
in Excel with the PasteSpecial command. Due to lack of time
I've only made an example of copying data within the same
sheet, but maybe this can show you the right way ... .

Hope this is what you've needed

Rolf
------------------------------------
Rolf Neumann
Infineon Technologies
WS TI DS 15
Otto-Hahn-Ring 6
81730 Mnchen
Germany
Tel.: +49 89 234-44484
Fax : +49 89 234-718178
------------------------------------



-----Ursprngliche Nachricht-----
Von: Wills, Mark [mailto:MWills@tycoelectronics.com]
Gesendet am: Donnerstag, 4. April 2002 11:46
An: Vee Reflector (E-mail)
Betreff: vrf Copying sheet values

Hi All,
     I posted a this request earlier this last week and had one reply
offering a ready made solution at a fee which I don't want as I have most of
the code completed and am only missing this last bit, so I'll try my luck
again.

Please can anybody help with the correct command syntax to copy only the
values from one sheet to another using PasteSpecial.
Just for info the two sheets are in different workbooks, although I this
shouldn't matters.

Any help would be greatly appreciated.

Regards,
Mark Wills

Principal ATE Engineer
Wireless Automotive System Group


---------------------------------------------------------------------
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".
---------------------------------------------------------------------

Outcomes