Maybe access can't find the path and folder to save the file in?
Try using a simple folder as a test like this:
"C:\MyTest.xls"
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"ljg" <ljg@[EMAIL PROTECTED]
> wrote in message
news:OjVWufi7IHA.4536@[EMAIL PROTECTED]
>I am trying to Ex****t to a spreadsheet using the following code, but I
keep
>getting error
>
> "Run-Time error '2302' Can't save the output data to the file you've
> selected."
>
> This is my code:
>
> DoCmd.OutputTo acOutputQuery, "propertyrequest", acFormatXLS,
> "C\datastream\ex****t_data\Property" & "_" & UsrName & ".xls"
>
> I am assuming its the file format? I am using Access 2007, in a 2002 -
> 2003 format and using Excel 2007 set to save in Excel 97 - 2003 format.
>
> I am running Vista Ultimate.
>
> Any help would be most welcome.
>
>
>
>
|
