topic Re: Macro - Corrrupt File..... How to Recover it................!! in QlikView

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

aveeeeeee7en — Mon, 27 Jul 2015 09:37:47 GMT

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:

Regards

Av7eN

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

marcus_sommer — Mon, 27 Jul 2015 10:20:56 GMT

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

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

aveeeeeee7en — Mon, 27 Jul 2015 11:04:31 GMT

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

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

marcus_sommer — Mon, 27 Jul 2015 11:34:40 GMT

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