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".
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".
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: 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".