Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report output to Excel causes NULL error in OfficeXP in Sum(XYZ) field

Status
Not open for further replies.
pdupreez

pdupreez

Technical User
May 16, 2001
49
ZW
I have a simple report showing daily despatches per month, including totals per day. When I export the report via VBA using DoCmd.OutputTo acOutputReport, "rptdaily", acFormatXLS, "C:\temp\rptdaily.xls", False, I get an #NAME# error in Excel(XP), which causes Excel to restart and recover.

However, if I convert the same report using the Export command from the Access menu, it translates correctly without error?

I am at a loss what the difference is. I do not have the same problem when I use Office97.
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
513
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
402
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
549
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top