Macro returning to module after completion

[agni_gold]

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

[agni_gold]

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.

[olivierrobin]

no more ideas for the moment .....

[agni_gold]

No problem, thanks for the discussion.

[tamilarasu · Accepted solution]

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

[agni_gold]

Thanks, Arasu !!

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

[tamilarasu]

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!.

[agni_gold]

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

[tamilarasu]

Hi Agnivesh,

Did you trace which line is not working?