AnsweredAssumed Answered

vrf FW: ActiveX using Microsoft Excel

Question asked by gregwale on Oct 19, 2003
Latest reply on Oct 19, 2003 by gregwale

Like • Show 0 Likes0
Comment • 3

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=Section1>Richard,Also, Vxl copies a sheet automatically tothe end of the workbook when sending 3d arrays, or a record array as discussedin some of the recent VEE days seminars. I also explained using built-in functions/ Type Conversion / asVariantNull() from Vee 6.x. Didn’t you attendJ ? Regards,Greg Wale<a href="http://www.passtechnologies.com/">www.passtechnologies.com</a>free demo at: <ahref="http://www.passtechnologies.com/vxlpage.html">www.passtechnologies.com/vxlpage.html</a> <div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>-----Original Message-----
From: Brown, Michael L CAR [mailto:Michael.L.Brown@carrier.utc.com]
Sent: Wednesday, October 15, 2003 12:34 PM<fontsize=2 face=Tahoma>
Subject: RE: FW: ActiveX usingMicrosoft Excel <div>Richard,</div><div> </div><div>Attached is a solution incorporating Tom'ssuggestion and an example using a null variant for Before so that you can placethe copied sheet after a specified sheet.</div><div> </div><div>Regards,</div><div>Michael</div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: tom.vanttinen@nokia.com[mailto:tom.vanttinen@nokia.com]
Sent: Tuesday, October 14, 2003 4:11 AM
To: VEE vrf
Subject: [vrf] FW: ActiveX usingMicrosoft Excel<div>Try following:</div><div> </div><div>app.Workbooks(1).Sheets.Item("Sheet1").Copy(app.Workbooks(2).Sheets.Item("Sheet1"));</div><div> </div><div>TOM</div><div> </div><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: ext Bomar, Richard [mailto:richard.bomar@pw.utc.com]
Sent: 10 October, 2003 19:09
To: VEE vrf
Subject: [vrf] ActiveX usingMicrosoft ExcelI am currently trying to copy sheets from one workbook toanother using Excel via VEE. I have not been able to find the proper sequence/syntaxfor copying sheets within the same workbook, much less different workbooks.Does anyone have an example or has successfully completed such a task ? Themacro recorder in Excel returned the following when I copy a sheet to the sameworkbook in Excel: Sheets("Sheet1").SelectSheets("Sheet1").Copy Before:=Sheets(1)End Sub The only syntax which works in VEE is the following: ExcelApp.Sheets("Sheet1").Copy(); If I try to use the Before or After variant, VEE returns thefollowing error: "ActiveX......Unable to get the Copy property of theWorkSheet class." Any assistance will be greatly appreciated. <spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'><img border=0 width=66 height=75src="1_multipart/2_image001.jpg"><spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Standards Laboratory<spanstyle='font-size:26.0pt;font-family:"Comic Sans MS";color:blue;font-weight:bold;font-style:italic'>Richard D. Bomar<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>MCSE,MCP, MCP+I,<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>E-mail: richard.bomar@pw.utc.com<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Phone: 561-796-1224<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Beeper: 561-754-8201<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Fax: 860-755-8895 <img border=0 width=279 height=93 src="1_multipart/3_image002.gif"> </blockquote>---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to"leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". ---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". </blockquote></div></div>--- You are currently subscribed to vrf as: rsb@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@it.lists.it.agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></html>

No one else has this question

Outcomes

michael.l.brown Oct 14, 2003 11:34 PM

Hi Vrf,
attached is a simplified prog that demonstrates a VEE bug we found
recently. This bug requires a review of all our test sources and I don't why
we haven't found this earlier.

1. wrong execution flow ( step into the prog )
2. segmentation violation ( after paste an unpacked user object )

There are a lot of workarounds to avoid this behaviour, but I couldn't see
why it shouldn't work like it is. It's 'tested' with VEE 6.01/03 and you can
build a similar construct from scratch with the same effect.

What do you think ?
Best regards

Christian
BIOTRONIK GmbH & Co.
EIT-1/CW
D 12359 Berlin - Neukoelln
Tel.: +49 30 689 05 - 301
--------------------------------------
christian.wienhold@biotronik.de
--------------------------------------

Actions

michael.l.brown Oct 14, 2003 11:34 PM

Actions

gregwale Oct 19, 2003 9:26 PM

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=Section1>Richard,Also, Vxl copies a sheet automatically tothe end of the workbook when sending 3d arrays, or a record array as discussedin some of the recent VEE days seminars. I also explained using built-in functions/ Type Conversion / asVariantNull() from Vee 6.x. Didn’t you attendJ ? Regards,Greg Wale<a href="http://www.passtechnologies.com/">www.passtechnologies.com</a>free demo at: <ahref="http://www.passtechnologies.com/vxlpage.html">www.passtechnologies.com/vxlpage.html</a> <div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>-----Original Message-----
From: Brown, Michael L CAR [mailto:Michael.L.Brown@carrier.utc.com]
Sent: Wednesday, October 15, 2003 12:34 PM<fontsize=2 face=Tahoma>
Subject: RE: FW: ActiveX usingMicrosoft Excel <div>Richard,</div><div> </div><div>Attached is a solution incorporating Tom'ssuggestion and an example using a null variant for Before so that you can placethe copied sheet after a specified sheet.</div><div> </div><div>Regards,</div><div>Michael</div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: tom.vanttinen@nokia.com[mailto:tom.vanttinen@nokia.com]
Sent: Tuesday, October 14, 2003 4:11 AM
To: VEE vrf
Subject: [vrf] FW: ActiveX usingMicrosoft Excel<div>Try following:</div><div> </div><div>app.Workbooks(1).Sheets.Item("Sheet1").Copy(app.Workbooks(2).Sheets.Item("Sheet1"));</div><div> </div><div>TOM</div><div> </div><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: ext Bomar, Richard [mailto:richard.bomar@pw.utc.com]
Sent: 10 October, 2003 19:09
To: VEE vrf
Subject: [vrf] ActiveX usingMicrosoft ExcelI am currently trying to copy sheets from one workbook toanother using Excel via VEE. I have not been able to find the proper sequence/syntaxfor copying sheets within the same workbook, much less different workbooks.Does anyone have an example or has successfully completed such a task ? Themacro recorder in Excel returned the following when I copy a sheet to the sameworkbook in Excel: Sheets("Sheet1").SelectSheets("Sheet1").Copy Before:=Sheets(1)End Sub The only syntax which works in VEE is the following: ExcelApp.Sheets("Sheet1").Copy(); If I try to use the Before or After variant, VEE returns thefollowing error: "ActiveX......Unable to get the Copy property of theWorkSheet class." Any assistance will be greatly appreciated. <spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'><img border=0 width=66 height=75src="1_multipart/2_image001.jpg"><spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Standards Laboratory<spanstyle='font-size:26.0pt;font-family:"Comic Sans MS";color:blue;font-weight:bold;font-style:italic'>Richard D. Bomar<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>MCSE,MCP, MCP+I,<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>E-mail: richard.bomar@pw.utc.com<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Phone: 561-796-1224<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Beeper: 561-754-8201<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Fax: 860-755-8895 <img border=0 width=279 height=93 src="1_multipart/3_image002.gif"> </blockquote>---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to"leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". ---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". </blockquote></div></div>--- You are currently subscribed to vrf as: rsb@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@it.lists.it.agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></html>

Actions

3 Replies

michael.l.brown Oct 14, 2003 11:34 PM
Mark Correct
Correct Answer
Hi Vrf,
attached is a simplified prog that demonstrates a VEE bug we found
recently. This bug requires a review of all our test sources and I don't why
we haven't found this earlier.

1. wrong execution flow ( step into the prog )
2. segmentation violation ( after paste an unpacked user object )

There are a lot of workarounds to avoid this behaviour, but I couldn't see
why it shouldn't work like it is. It's 'tested' with VEE 6.01/03 and you can
build a similar construct from scratch with the same effect.

What do you think ?
Best regards

Christian
BIOTRONIK GmbH & Co.
EIT-1/CW
D 12359 Berlin - Neukoelln
Tel.: +49 30 689 05 - 301
--------------------------------------
christian.wienhold@biotronik.de
--------------------------------------
Like • Show 0 Likes0
Actions
michael.l.brown Oct 14, 2003 11:34 PM
Mark Correct
Correct Answer
Hi Vrf,
attached is a simplified prog that demonstrates a VEE bug we found
recently. This bug requires a review of all our test sources and I don't why
we haven't found this earlier.

1. wrong execution flow ( step into the prog )
2. segmentation violation ( after paste an unpacked user object )

There are a lot of workarounds to avoid this behaviour, but I couldn't see
why it shouldn't work like it is. It's 'tested' with VEE 6.01/03 and you can
build a similar construct from scratch with the same effect.

What do you think ?
Best regards

Christian
BIOTRONIK GmbH & Co.
EIT-1/CW
D 12359 Berlin - Neukoelln
Tel.: +49 30 689 05 - 301
--------------------------------------
christian.wienhold@biotronik.de
--------------------------------------
Like • Show 0 Likes0
Actions
gregwale Oct 19, 2003 9:26 PM
Mark Correct
Correct Answer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=Section1>Richard,Also, Vxl copies a sheet automatically tothe end of the workbook when sending 3d arrays, or a record array as discussedin some of the recent VEE days seminars. I also explained using built-in functions/ Type Conversion / asVariantNull() from Vee 6.x. Didn’t you attendJ ? Regards,Greg Wale<a href="http://www.passtechnologies.com/">www.passtechnologies.com</a>free demo at: <ahref="http://www.passtechnologies.com/vxlpage.html">www.passtechnologies.com/vxlpage.html</a> <div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>-----Original Message-----
From: Brown, Michael L CAR [mailto:Michael.L.Brown@carrier.utc.com]
Sent: Wednesday, October 15, 2003 12:34 PM<fontsize=2 face=Tahoma>
Subject: RE: FW: ActiveX usingMicrosoft Excel <div>Richard,</div><div> </div><div>Attached is a solution incorporating Tom'ssuggestion and an example using a null variant for Before so that you can placethe copied sheet after a specified sheet.</div><div> </div><div>Regards,</div><div>Michael</div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: tom.vanttinen@nokia.com[mailto:tom.vanttinen@nokia.com]
Sent: Tuesday, October 14, 2003 4:11 AM
To: VEE vrf
Subject: [vrf] FW: ActiveX usingMicrosoft Excel<div>Try following:</div><div> </div><div>app.Workbooks(1).Sheets.Item("Sheet1").Copy(app.Workbooks(2).Sheets.Item("Sheet1"));</div><div> </div><div>TOM</div><div> </div><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: ext Bomar, Richard [mailto:richard.bomar@pw.utc.com]
Sent: 10 October, 2003 19:09
To: VEE vrf
Subject: [vrf] ActiveX usingMicrosoft ExcelI am currently trying to copy sheets from one workbook toanother using Excel via VEE. I have not been able to find the proper sequence/syntaxfor copying sheets within the same workbook, much less different workbooks.Does anyone have an example or has successfully completed such a task ? Themacro recorder in Excel returned the following when I copy a sheet to the sameworkbook in Excel: Sheets("Sheet1").SelectSheets("Sheet1").Copy Before:=Sheets(1)End Sub The only syntax which works in VEE is the following: ExcelApp.Sheets("Sheet1").Copy(); If I try to use the Before or After variant, VEE returns thefollowing error: "ActiveX......Unable to get the Copy property of theWorkSheet class." Any assistance will be greatly appreciated. <spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'><img border=0 width=66 height=75src="1_multipart/2_image001.jpg"><spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Standards Laboratory<spanstyle='font-size:26.0pt;font-family:"Comic Sans MS";color:blue;font-weight:bold;font-style:italic'>Richard D. Bomar<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>MCSE,MCP, MCP+I,<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>E-mail: richard.bomar@pw.utc.com<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Phone: 561-796-1224<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Beeper: 561-754-8201<spanstyle='font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;font-style:italic'>Fax: 860-755-8895 <img border=0 width=279 height=93 src="1_multipart/3_image002.gif"> </blockquote>---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to"leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". ---
You are currently subscribed to vrf as: Michael.L.Brown@carrier.utc.com
To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email"vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to"owner-vrf@it.lists.it.agilent.com". </blockquote></div></div>--- You are currently subscribed to vrf as: rsb@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@it.lists.it.agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></html>
Like • Show 0 Likes0
Actions

vrf FW: ActiveX using Microsoft Excel

Outcomes

Related Content

Recommended Content