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 did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 3:08 PM, Zafar Iqbal <ziqba...@gmail.com> wrote: > 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 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 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 Mon, Dec 22, 2014 at 11:36 AM, Vaibhav Joshi <v...@vabs.in> wrote: >>> >>>> 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 this for you. God is here working through me for you.* >>>> >>>> On Mon, Dec 22, 2014 at 1:58 PM, Zafar Iqbal <ziqba...@gmail.com> >>>> wrote: >>>> >>>>> 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" <ziqb...@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 >>>>>>> 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 these closed files? Thanks for your guidance in advance. >>>>>>> Regards, >>>>>>> Zafar Iqbal >>>>>>> >>>>>> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Remove Coding.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
