Re: $$Excel-Macros$$ No. of Occurrence of char in string

hai all :i form hyderabad i want learn VBA Course can you suggest me any books or institutions in hyderabad. On Mon, Dec 12, 2011 at 8:18 PM, rajan verma wrote: > VBA Function Provided By Noorian is nice trick > > Try This with Shift +Ctrl+Enter > =SUM(IF(--CODE(MID(B3,ROW(INDIRECT("A1:A"&LEN(

Re: $$Excel-Macros$$ Need you help to solve out control query.

Dear Sir, I need manual input. Regards, Ankit On Mon, Dec 12, 2011 at 9:21 PM, Maries wrote: > Hi Ankit, > > Please confirm whether you want it by Auto number or manual input. > > Regards, > > MARIES. > > > On Sun, Dec 11, 2011 at 8:15 AM, Ankit Agrawal > wrote: > >> Thanks Maries for your va

Re: $$Excel-Macros$$ Help in preparing the column automatically

Need your help plz get it done. Dear Sir, I had some confusion regarding my sheet now it has been clear.Please find my new attachment.plz solve my below metion query * I shell start from beginning. * I have only two query. * Need symbol in coloumn "I" i.e. "Agreement", if vendor agreement(w

RE: $$Excel-Macros$$ Worksheet Function Requires Range object as parameter

Hello monkeyboy, Functions actually can modify worksheets. It's only when the functions are called from a worksheet formula that they can't. When a function is called from a worksheet formula, the function is considered a UDF or "user-defined function". When the function is called from other VB

Re: $$Excel-Macros$$ Help for If nesting formula

Hi yogi, Can use this formula too... =IF(SUM(--(A1:D1>5))>=2,"Good","Poor") (apply with Ctrl + Shift + Enter) Regards, MARIES. On Mon, Dec 12, 2011 at 7:00 PM, rajan verma wrote: > See the attached File.. > > > On Wed, Nov 30, 2011 at 8:39 PM, Sam Mathai Chacko wrote: > >> This formula would

$$Excel-Macros$$ Date Format

Dear Experts, How to convert these "text dates" into date format. e.g. mm-dd- 10-14-2011 Secondly, if "text dates" are not in proper format e.g. dd-mm- 15-4-11 06-05-2011 08-1-2011 formula required. Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation)

Re: $$Excel-Macros$$ Re: Need a Macro To Generate Tables with Statistical Calculations

Or, Use a validation list of all priorities in A1 & just select the priorities from the list. If you are using list, instead of LOOKUP you can link them directly as =$A$1, for the numbers as =B$1 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Need you help to solve out control query.

Hi Ankit, Please confirm whether you want it by Auto number or manual input. Regards, MARIES. On Sun, Dec 11, 2011 at 8:15 AM, Ankit Agrawal wrote: > Thanks Maries for your valuable feedback.But some query are still > exist plz solve out it. > > In the macro I need that if we want to enter one

Re: $$Excel-Macros$$ Delivery Status Notification

noorain bhai attachment is not accepting by the domain On Mon, Dec 12, 2011 at 8:47 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Attachment is missing. > > On Mon, Dec 12, 2011 at 8:31 PM, Shankar Bheema wrote: > >> >> Dear Experts Good Morning >> >> I am attaching an excel vba form. In which I

Re: $$Excel-Macros$$ Delivery Status Notification

Dear Shankar, Attachment is missing. On Mon, Dec 12, 2011 at 8:31 PM, Shankar Bheema wrote: > > Dear Experts Good Morning > > I am attaching an excel vba form. In which I placed a label, textbox and a > command button. *When we supply a file number, it should open all the > related PDF documen

$$Excel-Macros$$ Delivery Status Notification

Dear Experts Good Morning I am attaching an excel vba form. In which I placed a label, textbox and a command button. *When we supply a file number, it should open all the related PDF documents kept in a folder in a list box with hyperlinks to enable us to show the contents in pdf format.* Each

Re: $$Excel-Macros$$ Urgent - Macro Code required for Outlook

Hi Noorain, I am using Micorsoft Outlook 2007. Where can I find object library? Secondly I want sender name to automatically displayed as per email received. Regards, Kaushik Savla On Mon, Dec 12, 2011 at 8:28 PM, NOORAIN ANSARI wrote: > Dear Salva, > > First select *Tools-Reference-Microsoft

Re: $$Excel-Macros$$ Re: Convert XLS to XML

Try to recod the macro while saving your file in Xml format ChDir "C:\Users\Administrator\Desktop" ActiveWorkbook.SaveAs Filename:="C:\Users\Administrator\Desktop\Book1.xml", _ FileFormat:=xlXMLSpreadsheet, ReadOnlyRecommended:=False, CreateBackup:= _ False On Mon, Dec 1

Re: $$Excel-Macros$$ Re: Need a Macro To Generate Tables with Statistical Calculations

This ONE line formula should go in table!b2 and be copied across. Hope this gets you started. =SUMPRODUCT((Calculation!$A$2:$A$6000=$A$1)*(Calculation!$C$2:$C$6000={"incident","Service Request"})*(Calculation!$D$2:$D$6000=B$1)) Don Guillett SalesAid Software dguille...@gmail.com From: Atul vish

Re: $$Excel-Macros$$ Urgent - Macro Code required for Outlook

Dear Salva, First select *Tools-Reference-Microsoft Outlook 12.0 Object Liberary* Please use below code Sub outlook_mail() Dim olapp As Outlook.Application Dim olitem As MailItem Set olapp = New Outlook.Application Set olitem = olapp.CreateItem(olmailitem) With olitem .To = "noorain.ans...@gmai

Re: $$Excel-Macros$$ Excel Books or classes

Dear Hari, You can download below excel-macro workbook. http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ No. of Occurrence of char in string

VBA Function Provided By Noorian is nice trick Try This with Shift +Ctrl+Enter =SUM(IF(--CODE(MID(B3,ROW(INDIRECT("A1:A"&LEN(B3))),1))=CODE(C3),1,0)) On Mon, Dec 12, 2011 at 8:00 PM, NOORAIN ANSARI wrote: > Dear Hanumant, > > Please try it.. > > *Function Count_character(rng As Range) > Dim str

Re: $$Excel-Macros$$ No. of Occurrence of char in string

Dear Hanumant, Please try it.. *Function Count_character(rng As Range) Dim str As Variant str = Split(rng, "e") Count_character = UBound(str) End Function * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.b

Re: $$Excel-Macros$$ Help for If nesting formula

Dear Yogi, You can also try through UDF Nested_If *Function Nested_if(rng As Range) counter = 1 For Each cell In rng If cell.Value > 5 Then counter = counter + 1 End If Next If counter > 2 Then Nested_if = "Good" Else Nested_if = "Poor" End If** End Function * On Sat, Dec 10, 2011 at 4

Re: $$Excel-Macros$$ Urgent - Macro Code required for Outlook

Hi Noorain, Many thanks for the response. I tried but it is not working. Further I don't want any excel spreadsheet to be used. I just want to use only Outlook. Please suggest. Regards, Kaushik Savla -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ Re: Convert XLS to XML

Hi Gurus, Kindly help for the below query. Regards, Iqbal On Fri, Dec 9, 2011 at 12:35 PM, Iqbal Merchant wrote: > Hi Gurus, > I need a macro to convert the content of the file into xml format and the > converted file should get saved on desktop in .xml format. > Sample file attached. > Please