File Error. Some number formats....

[kbreiss]

"File Error. Some number formats may have been lost" I'm receiving this error when Access executes the w/ the following code...

DoCmd.OutputTo acOutputQuery, "qryRoRWebUpdates", acFormatXLS, "RoR_Web_Updates.xls", True

However the data within Excel looks fine...
Is there a way to avoid the error message?

Thanks in advance.
Kacy
________
Body Science

 

[ghudson]

Try turning the warnings off.

DoCmd.SetWarnings False
'your code
DoCmd.SetWarnings True 'you need to turn them back on

 

[kbreiss]

I'm actually getting the error in Excel...any ideas?
________
SICK FROM PAXIL

 

[ghudson]

No.

Try the TransferSpreadsheet() method instead.