AnsweredAssumed Answered

vrf Copying Excel worksheets

Question asked by VRFuser on Oct 18, 2007

Like • Show 0 Likes0
Comment • 2

Hi all,

is there a clever (fast) way within VEE to read arrays (BINBLOCK format) that are delivered from the instrument with the wrong bit order (no not the wrong byte order)?

Any help appreciated!

Bernd

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

No one else has this question

Outcomes

VRFuser Oct 16, 2007 2:39 AM

Hi All
I need to be able to copy worksheets from different csv files into a single new workbook. Has anybody done this before? Please can anybody help with an example.

Thanks in advance.
/Peter

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

Actions

VRFuser Oct 17, 2007 1:04 AM

Thanks for your support.
I have solved the problem using the built in Excel functions and with some additional commands. The trick was to find the pointer to the instance created by the Excel initialise ie the 'xlApp' variable.
I can post the code if anybody is interested.

Best regards
/Peter

_____

From: Rickey, Eddie [mailto:e-rickey@ti.com]
Sent: Tuesday, October 16, 2007 5:57 PM
To: Peter Vitai
Subject: RE: [vrf] Copying Excel worksheets

Peter,

Did your question get answered? If not, I have something close which I can modify and document for you to use.

Eddie Rickey

Engineering Technician

HVAL

Storage Products Advanced Characterization Engineering

Texas Instruments, Inc.

_____

From: Peter Vitai [mailto:Peter.Vitai@renesas.com]
Sent: Tuesday, October 16, 2007 4:05 AM
To: VRF
Subject: [vrf] Copying Excel worksheets

Hi All

I need to be able to copy worksheets from different csv files into a single new workbook. Has anybody done this before? Please can anybody help with an example.

Thanks in advance.

/Peter

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: e-rickey@ti.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

Actions

2 Replies

VRFuser Oct 16, 2007 2:39 AM
Mark Correct
Correct Answer
Hi All
I need to be able to copy worksheets from different csv files into a single new workbook. Has anybody done this before? Please can anybody help with an example.

Thanks in advance.
/Peter

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Oct 17, 2007 1:04 AM
Mark Correct
Correct Answer
Thanks for your support.
I have solved the problem using the built in Excel functions and with some additional commands. The trick was to find the pointer to the instance created by the Excel initialise ie the 'xlApp' variable.
I can post the code if anybody is interested.

Best regards
/Peter

_____

From: Rickey, Eddie [mailto:e-rickey@ti.com]
Sent: Tuesday, October 16, 2007 5:57 PM
To: Peter Vitai
Subject: RE: [vrf] Copying Excel worksheets

Peter,

Did your question get answered? If not, I have something close which I can modify and document for you to use.

Eddie Rickey

Engineering Technician

HVAL

Storage Products Advanced Characterization Engineering

Texas Instruments, Inc.

_____

From: Peter Vitai [mailto:Peter.Vitai@renesas.com]
Sent: Tuesday, October 16, 2007 4:05 AM
To: VRF
Subject: [vrf] Copying Excel worksheets

Hi All

I need to be able to copy worksheets from different csv files into a single new workbook. Has anybody done this before? Please can anybody help with an example.

Thanks in advance.

/Peter

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: e-rickey@ti.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

Registered in England & Wales under number 4586709
Renesas Technology Europe Ltd
Dukes Meadow
Millboard Road, Bourne End
Buckinghamshire SL8 5FH
UK

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Like • Show 0 Likes0
Actions

vrf Copying Excel worksheets

Outcomes

Related Content

Recommended Content