MS Office Access cannot start OLE server

[accessaspire219]

Hi I have a macro that writes the results of a query to an excel file. When this macro runs I get an error MS office cannot start OLE server just before it tries to write it to excel. Does anyone know what causes this error and what is the solution?
Any help is appreciated.
Thanks.

 

[boblarson]

What are your macro steps (actions, conditions, arguments, etc.)?

 

[accessaspire219]

Open Query
Query name: Query Name
View: Datasheet
Data Mode: Read Only

Output to:
Object Type: Query
Object name: Same as query name
Output format: MS Excel
Output File Name: outpultfile.xls
Auto-start: Yes
Template file: None
Encoding: None

Save
Object Type: Query
Object Name: Query Name

Close
Object Type: Query
Object Name: Query Name
Save: No

Hope this helps.

 

[boblarson]

So these are the EXACT arguments you have? Please provide the EXACT arguments (real names).

Output to:
Object Type: Query
Object name: Same as query name
Output format: MS Excel
Output File Name: outpultfile.xls
Auto-start: Yes
Template file: None
Encoding: None