help with excel

**Pieter Linden** · Jul 17 '05, 07:48 PM

Re: help with excel

"Socrates" <[email protected] om> wrote in message news:<be2k5o$18 [email protected] 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...

Modules: Transferring Records to Excel with Automation

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

help with excel

help with excel

Comment