topic Re: Macro returning to module after completion in QlikView

Macro returning to module after completion

agni_gold — Sun, 22 Apr 2018 19:56:58 GMT

Hi Friends,

I came to one situation ,

I have written macro to get owner of the files in directory , but when I run this macro from Button , then macro is running fine , but when it got completed it is again opens module. I am not understanding why it is happening .

Attaching my macro, please help

Re: Macro returning to module after completion

agni_gold — Sun, 22 Apr 2018 20:02:56 GMT

gwassenaar‌ can you please help me here.

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 06:48:25 GMT

Any one please help here!!

Re: Macro returning to module after completion

olivierrobin — Mon, 23 Apr 2018 07:06:25 GMT

hello

do you mean that macro editor window is opening after execution ?

it yes, it is beacause there's an error in your macro.

you have to check the code

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 07:33:44 GMT

Yes macro editor window is opening after execution.

But my required output came.

Can you please check my macro attached in original discussion and guide me where I am doing wrong .

Thanks

Re: Macro returning to module after completion

olivierrobin — Mon, 23 Apr 2018 07:48:13 GMT

which macro do you call in your button ?

and how are executed the 1st 5 lignes (they don't belong to a names macro ?)

did you check your variables names ?

Re: Macro returning to module after completion

olivierrobin — Mon, 23 Apr 2018 07:49:13 GMT

when I copy your code in macro editoer, and run Check, I have this error :

ActiveX component can't create object: 'Scripting.FileSystemObject' on line 3

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 08:03:25 GMT

processdocument macro running from the button.

And variables are correct.

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 08:04:08 GMT

So how can I fix this problem, if this is the error.?

Re: Macro returning to module after completion

olivierrobin — Mon, 23 Apr 2018 08:25:52 GMT

I has a problem with admin rights . it's now ok

i have the same problem : process a long time and then reshow the dialog editor

you will have to trace the execution of the macro by adding msgbox instructions to see where the problem is

what i did :

sub processDocument
msgbox "Process will start , Please click OK."

If objFSO.FileExists(OUTPUT_FILE) Then
msgbox "exist"
'you delete if you find it'
msgbox "Trouvé"

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 08:29:05 GMT

yes, I have tried many times, everything is working fine, but when macro got end it came to edit module page, not able to investigate.

Re: Macro returning to module after completion

olivierrobin — Mon, 23 Apr 2018 08:34:14 GMT

no more ideas for the moment .....

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 08:41:18 GMT

No problem, thanks for the discussion.

Re: Macro returning to module after completion

tamilarasu — Mon, 23 Apr 2018 09:07:20 GMT

Hello,

For me it is working fine and it did not show macro window. I have tested the code in V.12.10.

This is not related to your question but thought of sharing with you. If user type the file name in small letters then your current code will not execute the below line. You need to use "Ucase" statement here to avoid such scenario.

If UCase(objFSO.GetExtensionName(objFile.name)) = filetype Then

If UCase(objFSO.GetExtensionName(objFile.name)) = UCASE(filetype) Then

Re: Macro returning to module after completion

agni_gold — Mon, 23 Apr 2018 10:01:29 GMT

Thanks, Arasu !!

Yes, this was the issue, thank you so much !!

Re: Macro returning to module after completion

tamilarasu — Mon, 23 Apr 2018 10:51:17 GMT

Great. I have reviewed your code and changed the above line and ran it. I did not see pop up window. I thought this was not an issue. Anyway, I'm glad it worked out for you. Have a fantastic day!.

Re: Macro returning to module after completion

agni_gold — Tue, 24 Apr 2018 05:46:40 GMT

Hi Arasu ,

I came to one more situation ,

This macro is working fine to me on my local system , but when i am trying to run this from Remote desktop and trying to access UNC path , this macro is not working , do you have any idea , how to overcome with this issue ?

Thanks

Re: Macro returning to module after completion

tamilarasu — Mon, 30 Apr 2018 06:32:25 GMT

Hi Agnivesh,

Did you trace which line is not working?