$$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

hi group i want a vba code for call addin fuction before any workbook close. please provide me code please.. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Bo

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

Thanks bro.. On Mon, Jun 11, 2012 at 11:14 PM, ankur wrote: > *@ Noorain Sir... > only one word...Awesome. > * > > Regards: > CMA Ankur Pandey > > Visit My Site > > > > On Mon, Jun 11, 2012 at 11:01 PM, NOORAIN ANSARI > wrote: > >> Dear Ankur, >> >> Exc

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

*@ Noorain Sir... only one word...Awesome. * Regards: CMA Ankur Pandey Visit My Site On Mon, Jun 11, 2012 at 11:01 PM, NOORAIN ANSARI wrote: > Dear Ankur, > > Excellent Job.. > > I have improved it, see attached sheet.. > > > > -- > Thanks & regards, >

Re: $$Excel-Macros$$ Highlighting the Text based on the Week day.....

Why not use conditional formatting? On Tuesday, 12 June 2012, Mohammed Muneer wrote: > Dear Friends, > > ** ** > > If the day in col - A is Friday the Text in col - B should get highlighted > - please help me I need a VBA code in this to solve. > > ** ** > > My file carry large no.of

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

*hi Munner Solution given by Rajan and Noorain Sir had solved your problem,but due to curiosity i try to modify the solution of Noorain sir by adding option to highlight any day ,option given by input box take one look, i request other members to suggest me ,how it can be improve i don't have knowl

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

*hi Munner Solution given by Rajab and Noorain Sir had solved your problem,but due to curiosity i try to modify the solution of Noorain sir by adding option to highlight any day ,option given by input box take one look, i request other members to suggest me ,how it can be improve i don't have knowl

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Dear Vivek, Please find attached example sheet of Global Vlookup. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 11, 2012 at 8:59 AM, Vivek wrote: > How to use the Vlookup function in a separate excel file, to search for > file number f

Re: $$Excel-Macros$$ Clock Chart (Excellent)

Simply AwesomeUltimate Use of Excel Features !!! MAnGesh On Fri, Jun 8, 2012 at 6:36 PM, Deba Ranjan wrote: > Thanks Bhai. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI > wrote: > >> See attachment >> >> >> On Fri, Jun 8, 201

$$Excel-Macros$$ Folder access Logger.

hi all, i want a macro which can give me the user log. it means i have folder on my network and i want to maintain log for those users who are tring to access my folder and files innside the folder. i want username and filese which are trying to access and the time of access. please help me

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

Use =WEEKDAY(A3)=6 in conditional formating. Original message From:""Mohammed Muneer""< mmun...@ccc.com.qa >Date: 11 Jun 12 20:22:43Subject: $$ExcelMacros$$ FW: Highlighting the Text based on the Week day.To: Sorry I forgot to attaché the file… Regards, Muneer, CC… FORUM RULES (986+ member

RE: $$Excel-Macros$$ Name a table

Can u please attached sample data?? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: 11 June 2012 8:28 To: excel-macros@googlegroups.com Subject: Fw: $$E

Re: Fw: $$Excel-Macros$$ Name a table

can you share a sample file On Mon, Jun 11, 2012 at 8:27 PM, wrote: > Dear all, > > Please try to find out any solution! > > Sandeep Chhajer > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: chhajersand...@gmail.com > Sender: excel-macros@googlegroups.com > Date: Mon,

Fw: $$Excel-Macros$$ Name a table

Dear all, Please try to find out any solution! Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 11 Jun 2012 10:59:23 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macro

RE: $$Excel-Macros$$ Highlighting the Text based on the Week day.....

See the attached file. =TEXT(A1,"")="Friday" Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 11 June 2012 8:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros

RE: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 11 June 2012 8:12 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.

$$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

Sorry I forgot to attaché the file... Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 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 at

$$Excel-Macros$$ Highlighting the Text based on the Week day.....

Dear Friends, If the day in col - A is Friday the Text in col - B should get highlighted - please help me I need a VBA code in this to solve. My file carry large no.of this kind of data in my excel sheet. That's the reason I need to approach this method. If necessary please do it

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks group for wonderful Ideas. thank you very much.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:46 PM, Ahmed Honest wrote: > Rajan, > > 100% agreed, formulae of all Ms Excel can't be compare to the versality of > VBA. My solution is just one more way and yes

RE: $$Excel-Macros$$ Concatenate Problem.

good Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed Honest Sent: 11 June 2012 6:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate Problem. Rajan, 100% agre

Re: $$Excel-Macros$$ Concatenate Problem.

Rajan, 100% agreed, formulae of all Ms Excel can't be compare to the versality of VBA. My solution is just one more way and yes it will take more time or whatever it is. Moreover to give one more easy way it is answered. Know the end user who posted the query has alternate one which ever he/she fe

RE: $$Excel-Macros$$ Concatenate Problem.

I would also like to know , how will you concatenate 1000 strings without VBA. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed Honest Sent: 11 June 2012 6:26 To: excel-macros@googlegroups.com S

Re: $$Excel-Macros$$ Extract Comma separated Data

Thanks Maries Still learning! On 11 June 2012 19:11, Maries wrote: > HI David, > > *"Wrap Text" *only avoiding continues spaces from the cell text. That's > why output not containing any empty rows in between. > > If you check total length of cell - say "=LEN(B8)", its counting spaces > too. >

Re: $$Excel-Macros$$ Concatenate Problem.

Dear -- I deleted the email when i read it for the first time, thinking this will be easily answered by the group. Anyways see attach i have created an example of your file which you sent. Thanks, On Mon, Jun 11, 2012 at 3:57 PM, Deba Ranjan wrote: > Ahmed ji..i think the file is alre

Re: $$Excel-Macros$$ Concatenate Problem.

Ahmed ji..i think the file is already attached in this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote: > . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ Concatenate Problem.

Hi Deba, the same can be achieved without VBA let me know if you wish to have that. Just send me your file. I will send you the solution. On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan wrote: > Thanks.. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Mon, Jun 11, 2012

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:22 PM, Rajan_Verma wrote: > The sorter one: No Loops Required > > ** ** > > *If your data is Vertical then use this* > > ** ** > > Function ConcatAll(rngRange As Range) As String > > ConcatAll

RE: $$Excel-Macros$$ Concatenate Problem.

The sorter one: No Loops Required If your data is Vertical then use this Function ConcatAll(rngRange As Range) As String ConcatAll = Join(Application.Transpose(rngRange), ",") End Function If your Data is horizontal then use this Function ConcatAll(rngRange As Range) As S

RE: $$Excel-Macros$$ export Userform Listbox data to new excel worksheet

Sorter one Private Sub CommandButton1_Click() For i = 1 To Me.ListBox1.ListCount Me.Cells(i, 1) = Me.ListBox1.List(i - 1) Next i End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf O

Re: $$Excel-Macros$$ Concatenate Problem.

Thanks .very Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote: > See attached sheet. > > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > >> Dear Deba, >> >> Please try below UDF, See attached sheet.. >> >> *Function Concatenat

Re: $$Excel-Macros$$ Concatenate Problem.

Dear Deba, Please try below UDF, See attached sheet.. *Function Concatenate_Deba(rng As Range) Dim cell As Range Dim str As String For Each cell In rng str = str & cell & "," Next cell str = VBA.Right(str, Len(str) - 1) Concatenate_Deba = str End Function * -- Thanks & regards, Noorain Ansari w

$$Excel-Macros$$ Concatenate Problem.

Dear experts, Please find the attached file. There is 568 names listed in A2, I want the whole names should come in one single cell with comma. Please.. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, ac

Re: $$Excel-Macros$$ Need Help

*@ Noorain, thanks dear, thanks a lot. :)* On Mon, Jun 11, 2012 at 2:15 PM, NOORAIN ANSARI wrote: > Dear Indrajit, > > Please find attached Snapshot. > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jun 11, 2012 at 9:40

$$Excel-Macros$$ Name a table

Dear Mentors, I want to create tables in Excel 2010 as following My data in excel is Column 1.Column 2 Reserve_surplus Other_exp Capital Reserve. Salary Securities Premium. Printing Revaluation reserve. Insurance General Reserve.

Re: $$Excel-Macros$$ export Userform Listbox data to new excel worksheet

just put a comment on workbook.add because it takes to another workbook and keeps on adding it whenever u click on exportto excel. Regadrs, Gawli Anil On Mon, Jun 11, 2012 at 3:03 PM, NOORAIN ANSARI wrote: > Hi, > > Please find attached Sheet, > Hope it will help to you. > > > -- > Thanks & re

Re: $$Excel-Macros$$ export Userform Listbox data to new excel worksheet

Hi, Please find attached Sheet, Hope it will help to you. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 11, 2012 at 1:07 PM, Dhartikumar Sahu wrote: > Hi group > > need urgently help to export Userform Listbox1 data to new excel workshe

Re: $$Excel-Macros$$ Extract Comma separated Data

HI David, *"Wrap Text" *only avoiding continues spaces from the cell text. That's why output not containing any empty rows in between. If you check total length of cell - say "=LEN(B8)", its counting spaces too. I hope this clarify clear. On Mon, Jun 11, 2012 at 1:14 AM, David Grugeon wrote:

Re: $$Excel-Macros$$ Extract Comma separated Data

Hi Maries Interesting. Do you know what is going through Excels mind when it does that? Why it does not just end up with lots of empty rows? On 11 June 2012 17:19, Maries wrote: > HI, > > Use the below formula PFA. > * > =SUBSTITUTE(B2,",",REPT(" ",1000))* > > > > On Sun, Jun 10, 2012 at

Re: $$Excel-Macros$$ Extract Comma separated Data

Hello friends, after reples all commond plz explen. Thanks Anil -- FORUM RULES (986+ members already BANNED for violation) 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 atten

Re: $$Excel-Macros$$ Extract Comma separated Data

*@ David very good way to solve the above said query...It's really amazing trick... @ Maries.nice one TOday i learn two more tricks out of Countless.. * Regards: CMA Ankur Pandey Visit My Site On Mon, Jun 11, 2012 at 12:49 PM, Maries wrote: > HI, > > Us

Re: $$Excel-Macros$$ Extract Comma separated Data

HI, Use the below formula PFA. * =SUBSTITUTE(B2,",",REPT(" ",1000))* On Sun, Jun 10, 2012 at 11:50 PM, David Grugeon wrote: > Hi Nalini > > Select the data > Ctrl H to bring up the replace dialog > Click in the "Find what" box. Type a comma. > Click in the "Replace with" box. > Hold down A

Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....

--- On Fri, 8/6/12, NOORAIN ANSARI wrote: Humbaly requested not to e mail me in future ved -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code