Analyze with excel

  • Thread starter Thread starter shiro
  • Start date Start date
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.
 
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
Open SQL Script in Query Analyzer with Button Click 1
Excel Analyzing 3
Analyze It with MS Excel 1
ACCESS 2003 - Use VBA to Set Default Output Folder 1
Export a form's records to an Excel spreadsheet 6
Excel cmd button 5

Back
Top