help with excel

[Socrates]

Hello everybody,

I would like VB to read a database (mXn table) from MSexcel, store it in an
2-D array, (make necessary calculations) and save it back to MSexcel. Does
anybody know how I can do that?

Thanks in advance

[Pieter Linden]

Re: help with excel

"Socrates" <socrates@dot.c om> wrote in message news:<be2k5o$18 gh$1@ulysses.no c.ntua.gr>...[color=blue]
> Hello everybody,
>
> I would like VB to read a database (mXn table) from MSexcel, store it in an
> 2-D array, (make necessary calculations) and save it back to MSexcel. Does
> anybody know how I can do that?
>
> Thanks in advance[/color]

I'd just use a recordset and use this code...

http://www.mvps.org/access/modules/mdl0035.htm