I have a button that when I click on it, I want it to create an Excel Spreadsheet with 5 worksheets.

Also how can I change the cell formats in Excel from Access? i.e. I have an export function in Access that exports a table into excel, however I want to change the format in Excel i.e. Make the Column headings bold.

Any ideas how I can do this using Access VBA?

I think it's time you bought "Integrating Excel and Access" by O'Reilly. =)


mmcdonal

Look it up at: http://wrox.books24x7.com