AnsweredAssumed Answered

vrf AW: Reading data from an excel file

Question asked by detlef.baranski on Jun 28, 2004
Try this concept ( from Shawn originally) in a fromular box:

// Get a sheet.
Set sht = CreateObject("Excel.Sheet").Worksheets(1);
sht.Application.Visible = True;

// Setup a test array.
ary = [[1, 2, 3], [4, 5, 6], [7, 8, 9]];

// Try a couple things.
sht.Range("A1:C1").Value = ary;
sht.Range("A3:C5").Value = ary;
sht.Range("A7:A9").Value = ary;

Where ary is your data-output ....

best regards,

-----Ursprngliche Nachricht-----
Von: murat atasayar []
Gesendet: 28 June 2004 17:38
Betreff: [vrf] Reading data from an excel file

I am preparing a database by using Vee and MSexcel.I have finished the part
consisting writing data in excel sheet. However, i do not know how to read
these data from excel sheet. Could you please help me about this problem?

Thank you,

Best regards

This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at

You are currently subscribed to vrf as:
To subscribe send a blank email to "".
To unsubscribe send a blank email to "".
To send messages to this mailing list,  email "". 
If you need help with the mailing list send a message to "".