0

automatic refresh when opening the excel file

Jet Reports Historic Posts

February 12, 2015 14:44

None

Follow

Hello Luke,

Currently there isn't a built in way for Jet to auto-refresh the report when you open it. You will need to click on Report or Refresh to start running the report. I would assume that if you are skilled in macros you could write one to do this but that is outside my scope of knowledge. I did a quick search on the Community Site and found this post that might be helpful in your quest.

http://community.jetreports.com/viewtopic.php?f=7&t=2377&p=7021&hilit=auto+run+reports#p7021

May the force be with you.

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts February 12, 2015 14:44

  Dear all,
  
  is it possible to refresh the Report automatically, when opening the Excel file? If yes - how?
  
  What do I have to do?
  
  thanks for supporting me

• 0
  
  Jet Reports Historic Posts February 13, 2015 17:26

  Hi Luke
  
  I am an absolute newbie in JET. However, I had the same problem and solved it by putting the following VBA-code into the "This Workbook" - Module:
  
  Private Sub Workbook_Open() Application.Run "JetReports.xlam!JetMenu", "Refresh" End Sub
  As I said, I'm new to both JET and Excel so this solution might be neither "right" nor "elegant" but it does the trick for me at the moment.
  
  If you want to try it out make sure you save your report as a .xlsm - file.

• 0
  
  Jet Reports Historic Posts February 16, 2015 06:30

  Dear josalis,
  
  it works very good! This is what I have been looking for.
  
  thanks a lot for your help

• 0
  
  Jet Reports Historic Posts February 20, 2015 18:21

  Dear Luke
  
  You're very welcome. And I'm happy to help.
  
  Just to give a hint on future problems:
  
  To figure out the
  
  Application.Run "JetReports.xlam!JetMenu", "Refresh"part, I used the built-in macro-recorder (Excel). It seems to write horrible code but knows (by definition) the right commands. =)
  
  Josalis