p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   docmd.outputto (http://p2p.wrox.com/showthread.php?t=39566)

Scripts82 March 9th, 2006 04:19 AM

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!

Scripts82


All times are GMT -4. The time now is 09:36 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.