0

In Access, I know that there is a "Analyze it with Microsoft Office Excel" option, but i am creating a database and the person requesting this wants a command button on a form to do the same thing that the "Analyze it with Microsoft Office Excel" button does. So my question is can anyone help me write vba code to export a MS Access query into Excel, formatted the exact way the "Analyze it with Microsoft Office Excel" does?

2 Answers 2

0

this worked on the Northwinds db:

DoCmd.OutputTo acTable, "Customers", "MicrosoftExcelBiff8(*.xls)", "", False, "", 0

http://msdn.microsoft.com/en-us/library/aa141534(v=office.10).aspx

1
  • Thanks, Chris. Had to change False to true to open Excel, but it worked
    – Edmond
    Jul 13, 2011 at 22:05
0

If you want a lot more flexibility as to exactly what is being exported where to Excel then see

I've used such code as a starting point to, for example, include some heading and footer lines, starting the export below the above lines, remove columns from the spreadsheet which were placed there from the query, create multiple worksheets, etc, etc.

However if you want just something basic then Chris gave you the answer.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .