0

Macro to refresh THIS workbook

kkuziemska

June 08, 2018 06:56

None

Follow

Hi

I use

Application.Run "JetReports.xlam!JetMenu", "Refresh"

to refresh report. It works when there is one workbook open. 

But when there is more than one workbook open and I run my workbook with macro it shows empty option window

 

I thought that "ThisWorkbook.Activate" will help but it doesn't.

It looks like this code doesn't focus on workbook with macro but on all workbooks.

 

How can I make this work?

thanks for any advise 

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis June 08, 2018 14:26

  Hello -

  When a Jet report is refreshed, Excel will recalculate that workbook AND any other open workbook.

• 0
  
  kkuziemska June 13, 2018 13:24

  So there is nothing we can do about it? 

• 0
  
  Harry Lewis June 13, 2018 14:10

  There is no way to change Excel's behavior.

  The only option that I know of would be to first close any workbooks that you do not want to recalculate.

  Edited by Harry Lewis June 13, 2018 14:11