Access 2000 Freezes after Excel Export

[NeedHelp]

Using a Macro Output to Excel, Access freezes. Can someone help?

 

[Klatuu]

More detail please. post the commands you are using in the macro.

 

[NeedHelp]

Detail of the Macro is as follows:
SetWarnings = No
Echo = Off
RunMacro (runs a series of append queries to a table)
OutputTo
Object Type: Table
ObjectName: Outputfile
Output Format: Microsoft Excel (*.xls)
Output File: c:\Outputfile.xls
AutoStart: No

 

[Klatuu]

Using the TransferSpreadsheet would be better for this:
Do all your queries, then change the OutputTo to
Action = TransferSpreadsheet
Transfer Type = export
Table Name = Outputfile
File Name = c:\Outputfile.xls
Has Field Names = Yes (I think). Yes means the first row of data exported
will be the field names of the access table. If you don't want to have field
names (column headers) in Excel, choose No
Range = Depends. If you want to give the worksheet a name, you can put it
here

 

[NeedHelp]

I used the Transfer Spreadsheet but Access still freezes. I tried turning
SetWarnings to Yes and Echo On on both commands Transfer Spreadsheet or
OutputTo and Access works fine. However, I need the system interface with
the User to be turned off within this application. Is there any other way to
go about not having the User to click yes on each of the append query to get
their exported file?

 

[Klatuu]

SetWarnings should have no effect on this. There is something else going on
you haven't found yet. Since I do not use macros, I can't be sure of what
the problem may be. You might try converting your macro to code and try
running the code produced by the conversion to see if you get the same
results.

 

[NeedHelp]

I found the solution. I just needed to set Echo back On. Thanks for
directing me to the TransferSpreadsheet. It does have more options.

If I have a template I'd like to use, how does this work with Access
populating an Excel template.

 

[Klatuu]

Glad you found the problem.
I really don't know about using a template with a transferspreadsheet. I
have never tried it.