Using Analyze It with MS Excel

[jdtivoli]

Using the "Analyze It with MS Excel" function to export
access data from a form to an Excel workbook, it
automatically creates a workbook with the same name as the
form in Access that the data comes from.

Is there any way to specify a particular workbook to
export the access data to?
Or is there perhaps a better way all together, rather than
using the Tools\Office links\Analyze It with MS Excel
feature?

 

[Arvin Meyer]

Yes the Analyze It with MS Excel is the same as the OutputTo Method of the
DoCmd object. You can also use the TransferSpreadsheet Method. Both are also
available as macros, albeit without any error handling capability. Have a
look in the help files for those keywords.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access