"Analyse With Excel" code - I want it!!

G

Guest

Hi

I want to allow users to click a button and copy data from a background
table into Excel. How can I find the code that would achieve this?

Any help gratefully received.

Simon Jolley
 
S

SusanV

In the button's on click event:

DoCmd.OutputTo acOutputTable, "TableName", acFormatXLS,
"FilePathAndName.xls", -1
 

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

Word to Excel: Export comments with text and line number 0
vba powerpoint pasting named shape in selected named slides 0
Open specific hyperlink (accept) automatically in email with outlook 0
Pivot table - deducting sub-totals of income and expenditure 4
Automating analyse with Microsoft excel 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
display message box in excel(2003) using VBA word(2003) 0
Analysing data from several excel workbooks 1

Top