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()
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
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,
>
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
*
*
*
*
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$
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
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
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
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
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
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
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.
>
>
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
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
;> 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:
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
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,
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
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
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
>
> --
> ---
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
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
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
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
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
;> 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
>
rain.ans...@gmail.com> wrote:
>>>>>
>>>>>> Dear Sagar,
>>>>>>
>>>>>> First of all you have add library in VBE Area
>>>>>>
>>>>>> Step:- Tools-Reference-Microsoft Scrinpting Runtime.
>>>>>&
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
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,
>
>
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
>
>
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
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
32 matches
Mail list logo