AnsweredAssumed Answered

vrf xlLib.dataFromCells

Question asked by VRFuser on May 9, 2008
  • Comment • 1
Hi Lloyd
            what code are you using.
I don't know if the following is your problem  but I tried reading a cell using VBA in Excel on a cell (A6) with 1024 characters and then with  cell (A6) containing 1025 characters. If you use the .value property it works for both but if you use the .formula property it works for 1024 characters but fails for 1025 characters.
 
The VBA code I used was:-
 
Sub Test()
 
MsgBox Worksheets("Sheet1").Range("A6").Value
MsgBox Worksheets("Sheet1").Range("A6").Formula
 
End Sub
 
hope this helps
 
Les

 
 

----- Original Message -----
From: HYPERLINK "mailto:lpitney@controltechnology.com"Lloyd Pitney
To: HYPERLINK "mailto:vrf@agilent.com"VRF
Sent: Friday, May 09, 2008 12:27 PM
Subject: [vrf] xlLib.dataFromCells



Has anyone needed to read data from an Excel Cell, into VEE Pro, that has more than 1024 characters?

If so how did you get around the 1024 limitation of this Lib?

 

Lloyd Pitney

Quality Control

 

Control Technology Inc.

5734 Middlebrook Pike

Knoxville, TN 37921

865-584-0440 Ext. 223

 


---
You are currently subscribed to vrf as: HYPERLINK "mailto:lesord@ntlworld.com"lesord@ntlworld.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".


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