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