Output to Excel - EM: Microsoft Office Access Can't Start OLE Ser

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that contains the Output To command. The command is supposed
to start the Excel application after the Output To action runs. The
parameters for this command include:
1. Object Type - Query
2. Object Name - < query name >
3. Object Format -Microsoft Excel 97-2003 (*.xls)
4. Object File - C:\Report
5. Autostart - Yes

When I ran this macro, I received an error message stating that Microsoft
Office Access Can't Start OLE Server. Our Field Support team attempted to
re-install Microsoft Office/XP to make sure we capture all the components
required by the interface between Access and Excel. Still this approach did
not work. I would appreciate any other ideas that would help us resolve this
issue. I tried the Access Knowledge Base but did not get any satisfactory
results.
 
Hi - 2 things i found when using OutputTo --- must have .xls extension on
file name - so must be Report.xls, and not to use c:\ as is often Read Only
or is limited in some way if working on a network. I create a XLS folder and
put them all there. Works fine and loads Excel afterwards with no problem.
HTH --- Dika
 
Thanks for the tip. It worked for me.

Kernow Girl said:
Hi - 2 things i found when using OutputTo --- must have .xls extension on
file name - so must be Report.xls, and not to use c:\ as is often Read Only
or is limited in some way if working on a network. I create a XLS folder and
put them all there. Works fine and loads Excel afterwards with no problem.
HTH --- Dika
Click to expand...
 
Back
Top