Thread: docmd.outputto
View Single Post
  #1 (permalink)  
Old March 9th, 2006, 04:19 AM
Scripts82 Scripts82 is offline
Authorized User
Join Date: Feb 2006
Location: , , Singapore.
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default docmd.outputto

Hi all,

I am using the docmd.outputto function to output a report to microsoft excel.

The entire process goes on fine until when the excel file opens, i get this error message in excel:

"File error: data may have been lost"
Then, the cell which are supposed to display the "sum" shows #N/A

This problem will not occur if i output the file to a RTF.
The "sum" fields also displays properly.

Anyone know why?

Thanks in advance!