$$Excel-Macros$$ Enter value in Chrome

2013-03-21 Thread Kiran Kancharla
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

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

2012-09-06 Thread Kiran Kancharla
Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: 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

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

2012-09-06 Thread Kiran Kancharla
) after running. Thanks Regards, KSAGAR On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla srkira...@gmail.com wrote: Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools

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

2012-09-06 Thread Kiran Kancharla
hi noorain, yes i want to protect VBA Thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com 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 srkira...@gmail.com wrote: Hi, with the above

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

2012-09-06 Thread Kiran Kancharla
: 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, thanks a lot your quick responce.. thanks,u kiran On 9/6/12

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

2012-09-06 Thread Kiran Kancharla
@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, thanks a lot your quick responce.. thanks,u kiran On 9/6/12, NOORAIN ANSARI

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

2012-09-05 Thread Kiran Kancharla
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

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

2012-08-23 Thread Kiran Kancharla
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 praveshkash...@gmail.com wrote: Hi Excel Experts! Could you please solved this question though vb coding. if I select

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

2012-06-20 Thread Kiran Kancharla
Hi All, Please help me on this. On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla srkira...@gmail.comwrote: 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. Experts @ Please

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

2012-06-20 Thread Kiran Kancharla
...@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 Kancharla srkira...@gmail.comwrote: Hi All, Please help me on this. On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla srkira

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

2012-06-20 Thread Kiran Kancharla
On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla srkira...@gmail.comwrote: 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

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

2012-06-20 Thread Kiran Kancharla
;) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kiran Kancharla Sent: Wednesday, June 20, 2012 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Saving Photos from webpage Hi All, Is any one interested, if I am ready to pay

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

2012-06-20 Thread Kiran Kancharla
. ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kiran Kancharla *Sent:* Wednesday, June 20, 2012 11:06 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Saving Photos from webpage

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

2012-06-19 Thread Kiran Kancharla
, Jun 17, 2012 at 11:29 PM, Kiran Kancharla srkira...@gmail.comwrote: 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 chilexcel...@gmail.comwrote: Please see attached Used DownThemAll

Re: $$Excel-Macros$$ Translating

2012-06-17 Thread Kiran Kancharla
from VBA: https://sysmod.wordpress.com/2012/01/09/microsoft-translator-vba-code-sample/ ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kiran Kancharla *Sent:* Friday, June 15, 2012 11:44 AM *To:* excel-macros

$$Excel-Macros$$ Saving Photos from webpage

2012-06-17 Thread Kiran Kancharla
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

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

2012-06-17 Thread Kiran Kancharla
in Firefox, click Tools from the toolbar,) and then use Excel Insert Images (Chilexcel) Direct and from Hyperlink http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp Chilexcel 2012/6/17 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please help to create a Macro

$$Excel-Macros$$ Translating

2012-06-15 Thread Kiran Kancharla
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

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

2012-05-20 Thread Kiran Kancharla
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

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

2012-03-28 Thread Kiran Kancharla
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 me

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

2012-03-28 Thread Kiran Kancharla
* * * * 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 haseeb.avarak...@gmail.comwrote: Hello Kiran, In G4 with CTRL+SHIFT+ENTER, rather than just ENTER

$$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread Kiran Kancharla
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(Feb).Visible =

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

2012-02-26 Thread Kiran Kancharla
*. 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 srkira...@gmail.comwrote: Hi All, Below is the Macro I have recorded for unchecking the Pivot

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

2012-02-01 Thread Kiran Kancharla
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

$$Excel-Macros$$ Attendance Tracker

2011-12-11 Thread Kiran Kancharla
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$$ Like pivot table function

2011-08-12 Thread Kiran Kancharla
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 rajanverma1...@gmail.comwrote: Can you please explain it more, Do you want to Extract three Record which total is ? -Original Message- From: excel-macros@googlegroups.com

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

2011-06-03 Thread Kiran Kancharla
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 excel file

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

2011-01-03 Thread kiran Kancharla
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 rajafs...@gmail.com wrote: hi friends, please help on my below querry. Thanks On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra

Re: $$Excel-Macros$$

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

Re: $$Excel-Macros$$ Missing Entries

2010-12-16 Thread kiran Kancharla
Have u tried using Vlookup? On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain vebhav.j...@gmail.com 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

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

2010-12-16 Thread kiran Kancharla
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 santanu...@gmail.com wrote: I want to Add two digit or multiply as this way. Column A   Column

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

2010-11-23 Thread kiran Kancharla
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 kumar.bemlmum...@gmail.com wrote: Is it not possible that MS Excel control has changed. On Tue, Nov