0

VBA and Jetreport Refresh

Jet Reports Historic Posts

January 30, 2014 21:39

None

Follow

I want to have a macro trigger when jetreport refreshes. Any suggestion?

Basically I want a simple copy and paste as values on a couple of cells to trigger upon jetreport refreshing.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 05, 2015 21:34

  Instead of hitting the Refresh button on Jet and trying to get a macro to run after that I would suggest triggering the Refresh from the macro prior to the rest of the code. This is what I do and it works like a champ!
  
  This can be done with something like this in VBA:
  
  Sub Macro()
  
  'Refresh Jet
  Application.Run "JetReports.xlam!JetMenu", "Refresh"
  
  'Continue with the rest of your VBA project
  ………
  
  End Sub

• 0
  
  Jet Reports Historic Posts January 12, 2015 15:56

  Awesome use of VBA.
  
  Jet Reports Tech support's official stance on macros is that they aren't supported.
  
  An alternative that avoids the use of Macros would be to use the Jet Scheduler tool. On the Output tab create a "Values Only Workbook". This option will create a copy of the report that only has Fixed Values and Excel Functions. All Jet Functionality will be removed.
  
  Extra bonus, there's an option to "Remove hidden rows, columns and sheets" which is useful if you have a DataDump column or Hidden Options page.