Refresh report from VB (again!)

[deetee2k]

This has been asked here before, but the thread didn't seem to get anywhere...
I'm using the following code to (automagically) export a report to Excel format,

set report=crxApp.OpenReport(rpt_name)
With report
.ExportOptions.FormatType = crEFTExcel80
.ExportOptions.DestinationType = crEDTDiskFile
.ExportOptions.DiskFileName = excel_file.xls
.Export(False)
End With

It works fine (can't get rid of the annoying export progress dialogue but that can be tolerated) except for the fact that I cannot update the report from VB, i.e. no report.refresh method.

Anyone with a greater knowledge of the RDC object model have any ideas? Ta, sorry for asking this again by the way...

D. "I want to play..."
(Guess the episode!)

 

[Ngolem]

Have you enabled the refresh button on the report viewer??

It looks like a lightening bolt

I haven't done this at all but think there is an "EnableRefreshButton" object in VB

Jim