$$Excel-Macros$$ Pivot uncheck All

Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage = "(All)" With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month") .PivotItems("Jan").Visible = False .PivotItems("Fe

Re: $$Excel-Macros$$ Pivot uncheck All

der > *PivotTable > Tools*. In the *Actions* group, click *Clear*, and then click *Clear > Filters*. Be sure you really want to do this before you undo all your > selections. > > > On Sun, Feb 26, 2012 at 11:45 PM, Kiran Kancharla wrote: > >> >> Hi All, >

$$Excel-Macros$$ Formula for Unique Values with Condition

Hi All, In the attached file I have names of the people who left the company. I need a formula to Extract the names of the Team Leader's and Team Manager's, where in Column "C" have Agent. I mean, I want to get only those Names, where they have attrition for "Agent" Request you to please help m

Re: $$Excel-Macros$$ Re: Formula for Unique Values with Condition

* * * * Hi Noorain/Haseeb, Perfect answers. This is what I was looking for... Thanks... Kiran On Thu, Mar 29, 2012 at 9:06 AM, Haseeb A wrote: > Hello Kiran, > > In G4 with CTRL+SHIFT+ENTER, rather than just ENTER > > > =IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

Hi Ayush, Agree with your New rule. As a second thougt, is this ok if people send information about relevant postings? I mean about MIS, WFM, VBA development jobs... these are very help for those, who are sarchig jobs and searching for candidates... Please consider this as a suggistion On

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

Hi Anil, Follow the below steps. Open the file click the below following steps File > Properties -> Summary -> and Uncheck the "Save Preview Picture" Regards, Kiran On Fri, Jun 3, 2011 at 3:18 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi members, > > > > My

Re: $$Excel-Macros$$ Like pivot table function

Any special reason for not using "Sumif"/ like : =SUMIF(A:B,H2,B:B) On Thu, Aug 11, 2011 at 7:34 PM, Rajan_Verma wrote: > Can you please explain it more, Do you want to Extract three Record which > total is > ? > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ Translating

Hi All, Request you to please let me know, is there any Inbuilt formula or a Macro to translate words in Excel. -- Thanks & Regards, Kiran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

Re: $$Excel-Macros$$ Translating

trick O'Beirne, on > his blog, for utilizing the MicrosoftTranslator.com API for free from VBA: > https://sysmod.wordpress.com/2012/01/09/microsoft-translator-vba-code-sample/ > > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googleg

$$Excel-Macros$$ Saving Photos from webpage

Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified l

Re: $$Excel-Macros$$ Saving Photos from webpage

fox, click Tools from the toolbar,) > > and then use > > Excel Insert Images (Chilexcel) Direct and from Hyperlink > http://www.youtube.com/watch?v=B1qUrTKsnGo&feature=plcp > > > > Chilexcel > > > > 2012/6/17 Kiran Kancharla : > > > > Hi A

Re: $$Excel-Macros$$ Saving Photos from webpage

Sun, Jun 17, 2012 at 11:29 PM, Kiran Kancharla wrote: > Hi *Chilexcel*, > > Thanks for your reply. I will check and let you know at the earliest. > > > Thanks & Regards, > Kiran > > > On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel wrote: > >> Please see attac

Re: $$Excel-Macros$$ Saving Photos from webpage

Hi All, Please help me on this. On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla wrote: > Hi Chilexcel, > > Apologies for delay in response. > > As suggested by you, I have tried the steps. It > require manual interaction of click and download the photos. > >

Re: $$Excel-Macros$$ Saving Photos from webpage

ce Executive > Info Edge India Limited (naukri.com) > Phone.: +91-9716615535 > naukrikuld...@gmail.com || www.naukri.com > *Please* *Consider the environment. Please don't print this e-mail unless > you really need to.* > > > On Wed, Jun 20, 2012 at 4:56 PM, Kiran

Re: $$Excel-Macros$$ Saving Photos from webpage

ds, Kiran On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla wrote: > > Hi All, > > Request you to please help to create a Macro to save images folder. > > Below are the requirement: > > Step 1: Navigating the website : http://www.jabong.com/ - Macro Done > Step 2

Re: $$Excel-Macros$$ Saving Photos from webpage

;> Application.Workbooks.Open ("http://www.jabong.com";) >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> From: Kiran Kancharla >>> Sent: Wednesday, June 20, 2012 1:

Re: $$Excel-Macros$$ Saving Photos from webpage

ing to save it to disk first. >> >> *All these methods would probably require:* >> >> ** i. **Download the HTML >> page with the search results. >> >> **ii. **Parse the HT

Re: $$Excel-Macros$$ Re: plz solve problem

Please have a look on the file. I am sure sure abt AHT as u have not provided the remaining details for AHT calculation.. On Fri, Aug 24, 2012 at 12:29 AM, PRAVESH KUMAR wrote: > Hi Excel Experts! > > > > Could you please solved this question though vb coding. > > if I select start date and en

$$Excel-Macros$$ Excel macro to add VBA password

Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks & Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BAN

Re: $$Excel-Macros$$ Excel macro to add VBA password

;> Set MyFolder = fso.GetFolder(YourFolderPath) >> >> For Each MyFile In MyFolder.Files >> >> MyFile.Password="abc" >> >> Next >> >> End Sub >> >> >> >> On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla >

Re: $$Excel-Macros$$ Excel macro to add VBA password

rain.ans...@gmail.com> wrote: >>>>> >>>>>> Dear Sagar, >>>>>> >>>>>> First of all you have add library in VBE Area >>>>>> >>>>>> Step:- Tools-Reference-Microsoft Scrinpting Runtime. >>>>>&

Re: $$Excel-Macros$$ Excel macro to add VBA password

hi noorain, yes i want to protect VBA Thanks, kiran On 9/6/12, NOORAIN ANSARI wrote: > Means, You want to protect VBA Coding instead of Opening File. > Kindly confirm. > > On Thu, Sep 6, 2012 at 6:32 PM, Kiran Kancharla > wrote: > >> Hi, >> >> with the abo

Re: $$Excel-Macros$$ Excel macro to add VBA password

Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Kiran Kancharla > Sent: 06 September 2012 12:08 > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password > > Hi, > >

Re: $$Excel-Macros$$ Excel macro to add VBA password

rsive:=True).Execute > End If > > 'Not the right password > If vbProj.Protection = 1 Then > SendKeys "%{F11}", True > End If > > 'Reset Password > Password = "" > > Application.ScreenUpdating = True > Set vbProj = Nothing > >

$$Excel-Macros$$ Attendance Tracker

Hi All, Request you to please share, If you have any tool or tracker for Maintain the attendance for a Team of 15 People Thanks in advance -- Thanks & Regards, Kiran -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Asa, I agree with you. Excel can extract Web query. In my current requirement i don't have a constant URL to download the data. Like www.Google.com -> Calender -> (My case URL is only one) These kind of URLS I have. The Macro need to open IE click on Specified links and copy the data to Ex

$$Excel-Macros$$ Enter value in Chrome

Hi All, Good Day. Please help me with a macro, which can enter value in Chrome or Firefox. I have a code to do the same in IE but the site response is very slow.. By using below code I am able to open the page.. Please help to get a code for entering the value in text box.. Sub Open_Chrome()

Re: $$Excel-Macros$$ Zooming of Excel Sheet.

U need to change the options. Tool ---> Options --> General "Zoom on roll with Intellimouse" This has to Uncheck. please try and let me know. On Tue, Nov 23, 2010 at 10:42 AM, C.G.Kumar wrote: > Is it not possible that MS Excel control has changed. > > > On Tue, Nov 23, 2010 at 10:09 AM,

Re: $$Excel-Macros$$ Missing Entries

Have u tried using Vlookup? On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain wrote: > Hi All, > Please help me in finding the missing entries from the below data. > ListA            ListB >   1                   1 >   2                   3 >   3                   5 >   4 >   5 > Regards > Vebhav Ja

Re: $$Excel-Macros$$ Problem regarding sum

In th cells do u have formatting or value like "Rs. 5.00" If it is the Formatting then u can do directly or if it is the value u need use "Find" formula On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca wrote: > I want to Add two digit or multiply as this way. > > Column A   Column B >  Rs. 5.00

Re: $$Excel-Macros$$

Simply u can use Find and replace. On Thu, Dec 23, 2010 at 3:48 PM, Rajiv Kumar wrote: > Dear sir > > how can sum with rupees simbol. > > It yes then please give me tips. Awating your positive replay… > > > > > Raj > > -- > ---

Re: $$Excel-Macros$$ Description while using Macro Functions in Excel

Hi Raj, the option is avaliable in all the versions of 2003 and later. which one you are using??? Thanks & Regards, Kiran On 1/3/11, Raj Mahapatra wrote: > hi friends, > > please help on my below querry. > > Thanks > > On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra wrote: > >> hi Group, >> >> i