0

Jet Report 7.1.0: Refresh cache with a macro

Jet Reports Historic Posts

February 06, 2015 08:05

None

Follow

One of our customers use Jet Reports 7.1.0. We use some macros to run the reports. I use the following command:
Application.Run "JetReports.xlam!JetMenu", "Report"

This one activates the "Report"-function in Jet Reports and runs the report. But how do I activate the "Run report and refresh the cache"-function?
I've tried this but it doesn't work:
Application.Run "JetReports.xlam!JetMenu", "Refresh"

Thank you in advance!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts February 06, 2015 17:35

  As Jet Reports v7.1 was available only as a .XLA file, are you accessing that instead of the .XLAM?
  
  e.g., Application.Run "JetReports.XLA!JetMenu", "Refresh"
  
  Do you get some error in VBA when you attempt it?