Create an Excel Spread with multiple worksheets
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?