Report not refreshing/renaming a new tab after macro is run

Hi,

I am not able to refresh the document again or rename a new tab in the same document after running a macro which does an export to excel.

Please help.

Thanks & Regards,


JAASI (BOB member since 2004-06-08)

Did your Macro Code at point set the Application.Interactive Property to False??? What happens if you close BO and open the report again??? Are you able to do those actions??? If so then it looks like the Excel Macro has set the property to False and failed to set it back to True…


Sridharan :india: (BOB member since 2002-11-08)

Hi Sri,

Yes the Application.Interactive property was set to false. I have reset this at the end and the report is working fine.

Thanks & Regards.


JAASI (BOB member since 2004-06-08)