Hey Guys.
I was wondering if someone could help me. I am trying to automate an access
db that cleans data, runs a bunch of queries, and then exports it to an
excel file.
I have the vb code written for everything but the export to excel. Can
anyone let me know how this can be done automaticallt using VB. Or if there
is a website that explains the process.
I really appreciate any assistance you could provide.
Thanks,
-Michael
Brian Bastl - 20 Jan 2006 04:37 GMT
search your vba help for TransferSpreadsheet
you might also search m.p.a.externaldata
and search google archives
Brian
> Hey Guys.
>
[quoted text clipped - 11 lines]
>
> -Michael
Michael - 24 Jan 2006 15:11 GMT
Got it. Thanks!
> search your vba help for TransferSpreadsheet
> you might also search m.p.a.externaldata
[quoted text clipped - 19 lines]
> >
> > -Michael