AnsweredAssumed Answered

AW: vrf import Data from an Excel sheet with DataFromCells

Question asked by VRFuser on May 2, 2006
Latest reply on May 2, 2006 by VRFuser
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
*******************************************

Outcomes