copy data from excel into an array

[Nuqe]

I have an excel file and would like to manipulate the data and merge a couple of excel files. the only way i know how to do this is to copy all the data from the excel files into an array... manipulate it there and then store it back into an xls. i'm not familiar with accessing data in excel with vb so if it would be possible for somebody to point me to a thread or website that would be great.

thanks

Nuqe

We all know about the "stupid user" don't we...

 

[fredericofonseca]

Search the forums for VB, EXCEL and range and you will find a few examples of how to deal with Excel data.

There is some items on the FAQ's also.

Both for
Visual Basic(Microsoft): Version 5 & 6
and
VBA Visual Basic for Applications (Microsoft forums

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com