Use your activeX code instead.
You can “Mix†all these things as this is more or less the same.
Just make sure that your objects starts with the correct set of   VXL-Objects …. Which is xlApp.xxxx
Â
Â
Otherwise send a short sample code of your problem…
Â
detlef
Â
-----Ursprüngliche Nachricht-----
Von: Willging, Claudia [mailto:claudia.willging@kriwan-testzentrum.de]
Gesendet: Dienstag, 2. Mai 2006 10:20
An: VRF
Betreff: [vrf] import Data from an Excel sheet with DataFromCells
Â
Hello Vrf,
at the moment I`m trying to import data from an Excel spreadsheet into Vee 7.5 with the built-in function "DataFromCells". Normally this works perfectly. But my programm always comes to an error, as soon as the number of characters in one cell exceeds a certain length. This phenomenon did not appear in Vee 6 with ActiveX. What can I do about this problem? I would like to make use of the new built-in functions in Vee 7.5.
Mit freundlichen Grüßen
i. A. Claudia Willging
-----------------------------------------------------------------------------------------
Dr. Claudia Willging
KRIWAN Testzentrum GmbH & Co. KG
D-74670 Forchtenberg
Tel.: (07947) 9150-0 (Durchwahl 9365) Fax: (07947) 9150-50
claudia.willging@KRIWAN-Testzentrum.de
HYPERLINK "file:///\www.KRIWAN-Testzentrum.de"www.KRIWAN-Testzentrum.de
KRIWAN Testzentrum auf der Control 2006
Besuchen Sie uns vom 09. - 12. Mai 2006 in der Messe Sinsheim
Sie finden uns in Halle 7 / Stand 7222
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
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 "www.oswegosw.com/vrf_archive/".
---
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 "www.oswegosw.com/vrf_archive/".
*******************************************
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und loeschen Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
Eingehende E-Mails mit folgenden Anhangs-Endungen werden aus sicherheitsgründen automatisch abgewiesen:
PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the contents in this e-mail is strictly forbidden.
Incoming E-Mails with the following attachement-extensions are automatically rejected for security reasons:
PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS
*******************************************
You can “Mix†all these things as this is more or less the same.
Just make sure that your objects starts with the correct set of   VXL-Objects …. Which is xlApp.xxxx
Â
Â
Otherwise send a short sample code of your problem…
Â
detlef
Â
-----Ursprüngliche Nachricht-----
Von: Willging, Claudia [mailto:claudia.willging@kriwan-testzentrum.de]
Gesendet: Dienstag, 2. Mai 2006 10:20
An: VRF
Betreff: [vrf] import Data from an Excel sheet with DataFromCells
Â
Hello Vrf,
at the moment I`m trying to import data from an Excel spreadsheet into Vee 7.5 with the built-in function "DataFromCells". Normally this works perfectly. But my programm always comes to an error, as soon as the number of characters in one cell exceeds a certain length. This phenomenon did not appear in Vee 6 with ActiveX. What can I do about this problem? I would like to make use of the new built-in functions in Vee 7.5.
Mit freundlichen Grüßen
i. A. Claudia Willging
-----------------------------------------------------------------------------------------
Dr. Claudia Willging
KRIWAN Testzentrum GmbH & Co. KG
D-74670 Forchtenberg
Tel.: (07947) 9150-0 (Durchwahl 9365) Fax: (07947) 9150-50
claudia.willging@KRIWAN-Testzentrum.de
HYPERLINK "file:///\www.KRIWAN-Testzentrum.de"www.KRIWAN-Testzentrum.de
KRIWAN Testzentrum auf der Control 2006
Besuchen Sie uns vom 09. - 12. Mai 2006 in der Messe Sinsheim
Sie finden uns in Halle 7 / Stand 7222
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
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 "www.oswegosw.com/vrf_archive/".
---
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 "www.oswegosw.com/vrf_archive/".
*******************************************
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und loeschen Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
Eingehende E-Mails mit folgenden Anhangs-Endungen werden aus sicherheitsgründen automatisch abgewiesen:
PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the contents in this e-mail is strictly forbidden.
Incoming E-Mails with the following attachement-extensions are automatically rejected for security reasons:
PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS
*******************************************
<b><span style='font-weight:bold'>Von:</span></b> Willging, Claudia[mailto:claudia.willging@kriwan-testzentrum.de]
<b><span style='font-weight:bold'>Gesendet:</span></b> Dienstag, 2. Mai 200610:20
<b><span style='font-weight:bold'>An:</span></b> VRF
<b><span style='font-weight:bold'>Betreff:</span></b> [vrf] import Data from anExcel sheet with DataFromCells</span></font></p><p class=MsoNormal style='margin-left:35.4pt'><font size=3face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hello Vrf,</span></font> </p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>at the moment I`m trying to import data from an Excelspreadsheet into Vee 7.5 with the built-in function "DataFromCells".Normally this works perfectly. But my programm always comes to an error, assoon as the number of characters in one cell exceeds a certain length. Thisphenomenon did not appear in Vee 6 with ActiveX. What can I do about thisproblem? I would like to make use of the new built-in functions in Vee 7.5.</span></font></p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Mit freundlichen Gren</span></font> </p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>i. A. Claudia Willging</span></font> </p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>-----------------------------------------------------------------------------------------</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Dr.Claudia Willging</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>KRIWANTestzentrum GmbH & Co. KG</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>D-74670Forchtenberg</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Tel.
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>claudia.willging@KRIWAN-Testzentrum.de</span></font>
<a href="file:///\www.KRIWAN-Testzentrum.de"><font size=2 face=Arial><spanstyle='font-size:10.0pt;font-family:Arial'>www.KRIWAN-Testzentrum.de</span></font></a></p><p style='margin-left:35.4pt'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>KRIWAN Testzentrum auf der Control 2006</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>BesuchenSie uns vom 09. - 12. Mai 2006 in der Messe Sinsheim</span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Siefinden uns in Halle 7 / Stand 7222</span></font> </p><p class=MsoNormal style='margin-left:35.4pt'><font size=3face="Times New Roman"><span style='font-size:12.0pt'>
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
To subscribe please send an email to:"vrf-request@lists.it.agilent.com" with the word subscribe in themessage 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"www.oswegosw.com/vrf_archive/". </span></font></p></div><BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to<BR>"owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY><!--[object_id=#kriwan-testzentrum.de#]--><P><FONT face=Arial size=2>*******************************************<BR>Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und loeschen Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.</FONT></P><P><FONT face=Arial size=2>Eingehende E-Mails mit folgenden Anhangs-Endungen werden aus sicherheitsgrnden automatisch abgewiesen:<BR>PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS</FONT></P><P><FONT face=Arial size=2>This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the contents in this e-mail is strictly forbidden.</FONT></P><P><FONT face=Arial size=2>Incoming E-Mails with the following attachement-extensions are automatically rejected for security reasons:<BR>PIF, SCR, BAT, URL, EXE, COM, DLL, HTA, VBS<BR>*******************************************<BR></FONT></P></html>