<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD><BODY><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004>Hi</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004>I'm getting tired of using "Unbuild Cord" so I wonder if it possible to manipulate data in a way alike it can be done with a Record ( rec.field)?</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004>Br</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=809344812-01072004>Steen Rudberg</SPAN></FONT></DIV>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<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 "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>
Just take the "range", this should give you the values. Works for me...
-Vinod
--- "Pickles, Warren" <Warren.Pickles@tycoelectronics.com> wrote:
> Hi,
>
> I'm reading data from an excel sheet into VEE. I use this formula:
> Set range = Wks.UsedRange;
> range.formula;
>
> ... where Wks is a worksheet object. The data on the worksheet end
> up in
> VEE as a 2D array which is exactly what I want. But if any cell
> contains a
> formula, VEE ends up with the text of the formula rather than the
> evaluated
> value. For example, if the cell contains "=2+3" then it shows up in
> excel
> as "5", and I want VEE to read it in as 5, but VEE reads "=2+3".
>
> Anyone got a fix? The range.value property gives evaluated formulae
> but
> that gives a record with thousands of fields which is useless to me.
>
> Thanks,
> Warren
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
---
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@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".