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 wrote: > Now, It is working excellent. Thanks for this great help, dear experts. > --- > > On Mon, Dec 22,

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 wrote: > Try this...Removed some bugs, now its working good... > > Cheers!! > > + > *I did not do this for yo

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 wrote: > Hi Zafar, > > Pls let us know error, before that .. > > Trust Access To Visual Basics Project must b

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 Options>Macro Settings>Developer Macro Settings, Tick Trust Access to the VBA object Try this file.. Cheers!! + *I di

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 wrote: > Dear Ashish > > Your Code is work

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 wrote: > Dear Vaibhav Joshi, all fil

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 M

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 th

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" > > wrot

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" 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 manually one > by one

$$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 t