Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Zafar Iqbal
If there is no short cut then I will follow your suggestion. Thanks for your guidance. On Sunday, December 21, 2014 11:16:34 AM UTC+3, Vabz wrote: Try to open file one by one using macro n save it as macro free workbook . Xlsx Cheers On Dec 21, 2014 1:03 PM, Zafar Iqbal

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Vaibhav Joshi
Hi Zafar, If this is not as per your requirement then macro can be made as per your need.. Coz.. .xlsx file extension is not supported in older version then in that case this solution will not work.. Do let us know if you want .xls extension post removal of VBE. Cheers!! + *I did not do

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Zafar Iqbal
Dear Vaibhav Joshi, all files are with extension xls. If code will temporarily or permanently do something with extension, it is no harm to me. I can handle both .xls and .xlsx without any difficulty. Thanks Regards, ZAFAR IQBAL --- On

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Vaibhav Joshi
Dear Ashish Your Code is working fine.. Dear Zafar, Check this file, i have modified Ashish Kumar's code to suit your need,,, Cheers! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 2:13 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Zafar Iqbal
Right now, I tried it and getting error message. Let me check possible corrections at my end. Thanks for this kindness. Regards, ZAFAR IQBAL --- On Mon, Dec 22, 2014 at 12:19 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Your

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Vaibhav Joshi
Hi Zafar, Pls let us know error, before that .. Trust Access To Visual Basics Project must be enabled. From Excel: Tools | Macro | Security | Trusted Sources.. or Excel OptionsMacro SettingsDeveloper Macro Settings, Tick Trust Access to the VBA object Try this file.. Cheers!! + *I did

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Vaibhav Joshi
Try this...Removed some bugs, now its working good... Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 3:26 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Zafar, Pls let us know error, before that .. Trust Access To Visual Basics

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Zafar Iqbal
Now, It is working excellent. Thanks for this great help, dear experts. --- On Mon, Dec 22, 2014 at 1:32 PM, Vaibhav Joshi v...@vabs.in wrote: Try this...Removed some bugs, now its working good... Cheers!! + *I did not do this

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-22 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 4:06 PM, Zafar Iqbal ziqba...@gmail.com wrote: Now, It is working excellent. Thanks for this great help, dear experts. ---

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-21 Thread Vaibhav Joshi
Try to open file one by one using macro n save it as macro free workbook . Xlsx Cheers On Dec 21, 2014 1:03 PM, Zafar Iqbal ziqba...@gmail.com wrote: I have +500 Excel files (*.xls) having macros, all located in same folder. I want to remove all macros from these files. Removing macros

$$Excel-Macros$$ How to remove excel macros from multiple closed files

2014-12-20 Thread Zafar Iqbal
I have +500 Excel files (*.xls) having macros, all located in same folder. I want to remove all macros from these files. Removing macros manually one by one from these files will take too much time. Is it possible to create a new macro in a separate excel file which will remove all macros from