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

$$Excel-Macros$$ Scale Chart for rating

2014-12-20 Thread Karan Singh
Hi Everyone, I need your idea and suggestion to make a line chart and scale chart based on dates and score. I've explained everything in excel file. I would request you to kindly suggest some idea or code so that I can make the scale chart. I've created line chart but I'm not able to make the sca

Re: $$Excel-Macros$$ solve vba Query

2014-12-20 Thread Vaibhav Joshi
Hi you gave output as CID, Cancelled & Partial Return. Is there only 3 values or more than that? + *I did not do this for you. God is here working through me for you.* On Sat, Dec 20, 2014 at 1:29 PM, sanjai Kumar wrote: > Dear All, > > In Attached Sheet extract Output data from Current St

Re: $$Excel-Macros$$ Add control on button click

2014-12-20 Thread Vaibhav Joshi
Hi Check this...macro adds textbox (text box) & commandbutton (command button) in run time, so i started with blank form, it loaded 3 rows in the beginning.. i kept at as standard you can not deleted beyond the 3 rows :P :/ I did changed add button position, i thought insted giving as option to u

$$Excel-Macros$$ solve vba Query

2014-12-20 Thread sanjai Kumar
Dear All, In Attached Sheet extract Output data from Current Status Column by vba text to column Regards Sanjai Kumar -- 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/discus