🚀 go-pugleaf

Thanks for the reply.

I would appreciate it if you could maybe give an example of the code.

I do a lot of database programming using DAO . e.g. database . recordset
definitions etc. Hope this will not be do much of a difference

thanks again

cheers

--
DME

Tom van Stiphout <tomvs@syspac.com> wrote in message
news:396c6ef3.1011935@news.syspac.com...
> On Wed, 12 Jul 2000 09:26:35 +0200, "David"
> <habanero.burns@mweb.co.za> wrote:
>
> Hi Mr. Habanero  (cool name :-)
>
> I would think you could use Automation to do this: set a reference to
> Access, then create an object of type Access.Application. At that
> point, the whole Access object model is available. I believe this will
> allow you to run a query or a public function in a module.
>
> I've typically gone the other way: the code in Access and Excel is
> just a dumb report writer. This works, but formatting cells is
> surprisingly slow.
>
> -Tom.
>
>
> >Hi All
> >
> > How do I write a function within Excel that will dsum an access database
> > table (based on certain criteria  from within the Excel procedure). In
> > essence I would like to create a report writer within Excel that the
user
> > can use to write reports based on data within an access table.
> >
> > Thanks for all your help
> >
> >
> >
> >
> >
> >
> >--
> >DME
> >
> >
> >
>