Analyze with excel

S

shiro

We access has capability to output the record to excel.
( Tool > Office Links > Analyze it with MS Excel ).

Please help me how to code it in the even of a command button.
But 'no need' to open the file after outputed it to excel.Thank's.
 
J

Jeanette Cunningham

Shiro,
look at TransferSpreadsheet, the help for it is in the help you find when
you have the code window open.

Jeanette Cunningham
 

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 to run menu selection "Analyze It with Microsoft Excel" 2
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1
ACCESS 2003 - Use VBA to Set Default Output Folder 1
analyze subform in excel 2
Export a form's records to an Excel spreadsheet 6
analyze data with excel feature in office 2007? 2
Command button for Analyze it with MS Office Excel? 2
Analyze It with MS Excel 1

Top