Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Macro - Corrrupt File..... How to Recover it................!!

Hi Experts

I used to send Excel file in Mail to specific users.

After selecting  Allow any macro (only for trusted documents) in Module Security for Document,

the file is not opening. How to recover it????

PFB the Error:

Appcrash.png

Regards

Av7eN

3 Replies
marcus_sommer

At first I would look if I have a backup or if I could create one (windows shodow copies, other snapshot tools, regular IT backup-tasks, manual backup's) and if not I would think about it.

Then I would try to open the app without data - the easiest way is per right-click on the app within the qv start-window.

- Marcus

aveeeeeee7en
Specialist III
Specialist III
Author

Thanks Marcus Sir for your reply.

I've a backup Process.

But I am looking for a Front end solution is there is any.

Regards

Av7eN

marcus_sommer

It seems that there are any conflicts caused through your last changes that probably activated an OnOpen-Trigger which tried to select or activate anything or similar. I think the only way is to make it undone and check and modify those logic to understand what's wrong - I mean comment the real statements out and use msgbox instead to see what would the routine do (selecting, activating, values from variables and so on).

- Marcus