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
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
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
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
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
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
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
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
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.
---
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
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
11 matches
Mail list logo