Invalid Directory error when exporting

[Joeyshin]

Hi,

I'm using CR8 and VB6, trying to export a report using
Report.Export True

I selected Excel7.0 format and filename "test.xls" at runtime system dialogs. After that, I got an "invalid directory" error and the code above was highlighted. Am I missing something here?

I found a previous post noting that "date/time" format filename could get this error message. But "test.xls" really sounds like an innocent filename?

Thanks,

Joe

 

[Joeyshin]

In case this helps,

the Export button on the ReportView control dose not export my report either, nomatter which exporting format. It basically asked me export format, filename, etc. Then passed without showing progress bar. A blank (empty) file with selected name was created on my disk.

Please suggest if there is something I missed. Thanks.