Using VB to export to excel

M

Michael

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
 
B

Brian Bastl

search your vba help for TransferSpreadsheet
you might also search m.p.a.externaldata
and search google archives

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Start a mail merge upon opening the document 1
Exporting Excel to web with VB functions 0
Outputting the status of the script... 2
Exporting Crystal Report to Word/Excel 2007 1
Export to Excel, name and format exported spreadsheets 0
Export table to Excel for emailing 8
Downloading Access database table into Excel (VB) 5

Top