Exporting to Word and Excel using RDC.

[CrystalVisualBOracle]

(-: Does anyone know where on the web I can find information on how to export a report I've created in a VB6 application using the RDC component. I need to do it in the background automatically rather than allowing the user to use the drop down list available on the viewer screen. Trouble is I've been looking in Seagate's Knowledge base for 30 minutes and I can't find anything referring to the actaul syntax I need to use. Micrsoft wasn't much help either. Any help with this would be greatly appreciated.

Thanks a lot,
Crystal VisualB Oracle

 

[DGA15]

I export reports to Excel from Vb 6.0.
create a Excel.Application, Workbook and Worksheet
.......
'below exports the complete matrix into the specified 'range. rowOffset & colOffset specify the top left hand row
'and column to put the matrix into.
dim r as range
With myWB
Set r = .myWs.Range.Cells(1 + rowOffset, 1 + colOffset),.Cells (ubound(myMatrix,1), ubound(myMatrix2)))
r = myMatrix
set r = nothing
.......
myExcelApp.close
set r = nothing
set myWs = nothing
set myWb = nothing