Export Report to Excel ???

[cutestuff]

hi,

I have the following code on my command button :

DoCmd.OutputTo acOutputReport, "rpt4point2PID", acFormatXLS, "C:\Documents and Settings\jsantos\Desktop\SBPH_PID.xls"

It exports my sheet, but it's giving me this error:
"Renamed Invalid Sheet Name"

Does anyone know why and how to fix it?
Please?

Thank you!!!

 

[thall29323]

Hello - While searching for my own answers, I ran across numerous posting concerning this behaviour in XL. Seems the export report function uses the report name to name the worksheet too. Try changing the report name to TEST, then do the export. Let me know what that does.