Error 2282

[bobh]

Hi All,

In AccessXP I have the following line of code, PathNme is a string
variable which contains the server-path and filename

DoCmd.OutputTo acOutputQuery, "Auto_Data_Dump_App", PathNme,
acFormatXLS, True

When I process this line I get the following error

" 2282 - the format in which you are attempting to output the current
object is not available. "
Well, I have ExcelXP installed, I have OfficeXP installed so I don't
know whats wrong here, any idaes????? Even stranger is
Docmd.TransferSpreadsheet works...........
thanks
bobh.

[Tom van Stiphout]

On 26 Apr 2007 06:46:31 -0700, bobh <vu******@isp.comwrote:

Carefully check your arguments with the help file. Currently PathNme
is the OutputFormat argument; you probably want it to be the
OutputPath argument.

-Tom.

>DoCmd.OutputTo acOutputQuery, "Auto_Data_Dump_App", PathNme,
acFormatXLS, True

[bobh]

Thanks for noticing that, what a DUH! :) placement is everything
bobh

On Apr 26, 10:16 am, Tom van Stiphout <[e-mail]:

On 26 Apr 2007 06:46:31 -0700, bobh <[e-mail]:

Carefully check your arguments with the help file. Currently PathNme
is the OutputFormat argument; you probably want it to be the
OutputPath argument.

-Tom.

DoCmd.OutputTo acOutputQuery, "Auto_Data_Dump_App", PathNme,
acFormatXLS, True- Hide quoted text -

- Show quoted text -