Using VB to export to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
search your vba help for TransferSpreadsheet
you might also search m.p.a.externaldata
and search google archives

Brian
 
Back
Top