TOPIC: Open RPT from VBA

Open RPT from VBA 26 Aug 2011 10:54 #866

  • MikeP
  • MikeP's Avatar
  • Offline
Hi,

I've downloaded the free crystal report viewer, i'm looking to open a report directly from a Access DB, previously have used Crystal Desk but isn't supported on Win7.

Code used previously was:

Call Shell("C:\Program Files\CrystalDesk\ReportViewer.exe C:\CRYSTAL REPORTS\Report1.rpt" )

and this would open report1 directly

Have tried similar with Logicity

Call Shell("C:\Program Files\SaberLogic\Logicity\Logicity Desktop.exe C:\CRYSTAL REPORTS\report1.rpt" )

but fails to open (or error) anything.

Is this feature available and if so anybody any ideas on how to do it?

Cheers

Darryl
The administrator has disabled public write access.

Re:Open RPT from VBA 29 Aug 2011 19:13 #868

  • sduranceau
  • sduranceau's Avatar
  • Offline
Hello,
Try putting double quotes around the path to your rrd.
This should fix the problem.
Also, try copying your rrd to a different location without spaces, such as the C:\ drive.
I hope this fixes your problem!

-Devin
The administrator has disabled public write access.