Re: $$Excel-Macros$$ Is it mandatory to keep the excel file as macro enable (if inside having macro) ?

2014-08-09 Thread Nur Hossain
Hi Paul, thanks for your valuable information.. On Sun, Aug 10, 2014 at 3:29 AM, Paul Schreiner wrote: > If you have macros in the file, then Yes, you must save it as either > .xlsm, .xlsb or .xls (Office-97) > If you save it as .xlsx, then all macros will be removed. > > It has been my experie

Re: $$Excel-Macros$$ Is it mandatory to keep the excel file as macro enable (if inside having macro) ?

2014-08-09 Thread Paul Schreiner
If you have macros in the file, then Yes, you must save it as either .xlsm, .xlsb or .xls (Office-97) If you save it as .xlsx, then all macros will be removed. It has been my experience that files saved in .xlsb format are smaller. Even though they may not have macros. In addition, macros that t

Re: $$Excel-Macros$$ Please create a macro of this sheet according urgent

2014-08-09 Thread kapil Gupta
Hello , Thanks to reply but i want to create new workbook and per individually wise create workbook.. for example:- A, b, c d== 1 workbook create A name 2nd workbook create B name and Third workbook create C name that's type Regards, Kapil Gupta On Saturday, August 9, 2014 7:15:46 PM UTC+5

$$Excel-Macros$$ Is it mandatory to keep the excel file as macro enable (if inside having macro) ?

2014-08-09 Thread Nur Hossain
Dear all, I am having an “Excel Macro Enable Workbook” & it works very well. Now if I save as it to “Excel Binary workbook “ . or save as it as normal “Excel workbook” only . in both case it works as well . but my question , is it mandatory to keep the excel workbook as macro enable where its havin

Re: $$Excel-Macros$$ Please create a macro of this sheet according urgent

2014-08-09 Thread Ashish Kumar
Hi Kapil, PFA !!! Regards Ashish On 9 August 2014 17:21, kapil Gupta < kgupt2...@gmail.com> wrote: > Hello, > > I have attached one sheet please create a macro as per unique name > required create workbook if the name is duplication but create workbook as > per unique name. > And i

$$Excel-Macros$$ Please create a macro of this sheet according urgent

2014-08-09 Thread kapil Gupta
Hello, I have attached one sheet please create a macro as per unique name required create workbook if the name is duplication but create workbook as per unique name. And if unique name is add more then also next time click the button and create workbook as per unique name. Regards, Kapi