Exporting CR from VB

am trying t export a report from CR ver 7.0 from VB 6.0
the report has 16000 rows, but its exporting only 8000+ records...
no error messages.
can anyone help me out.r u exporting to excel, if yes
try using

Report.Export

With Report.ExportOptions
.ExcelExportAllPages
End With

****where report is object of CRAXDRT.report

Dim Report As CRAXDRT.Report|||thanks sraheem for ur help.

yeah am trying to export to excel only.

i tried CRAXDRT

but i coud not find the option .ExcelExportAllPages with ExportOptions|||so sad to know that noone is there with a solution.

i thot its a simple problem and i didnt knew to solve it.

if anyone finds it out,...please let me know,sql