Thanks a lot Mohan, Its working fine and its allowing person to sign in via yahoo and gmail.
Can we send an email to someone by giving recipient ID through a macro ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. ________________________________ From: अनिल नारायण गवली <gawlianil8...@gmail.com> To: excel-macros@googlegroups.com; mohan.pande...@gmail.com Sent: Friday, 4 January 2013 10:52 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Dear Mohan, Pls find attached its give u some eg....to work.. Regards, Gawli Anil On Fri, Jan 4, 2013 at 10:48 AM, amar takale <amartak...@gmail.com> wrote: Hi Mohan, > > >A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price & after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query > > >Appreciate the help > > >Let us know in case of any further assistance. > > >Thanks & Regards > >Amar > > > >On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> >wrote: > >Thanks for providing the link Mohan. >> >> >>But unfortunately its giving me an error, file is corrupted and cannot be >>saved. >> >> >>Warm Regards >>Ankur >> >>________________________________ >> From: "mohan.pande...@gmail.com" <mohan.pande...@gmail.com> >>To: excel-macros@googlegroups.com >>Sent: Friday, 4 January 2013 12:13 AM >> >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >> >>The link which I have sent you is my blog and I have done this for google >>login. At that time it was working. >>Sent from BlackBerry® on Airtel >>________________________________ >> >>From: ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> >>Sender: excel-macros@googlegroups.com >>Date: Fri, 4 Jan 2013 02:40:10 +0800 (SGT) >>To: excel-macros@googlegroups.com<excel-macros@googlegroups.com> >>ReplyTo: excel-macros@googlegroups.com >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >>Thanks, so you meant that you have logged in to the account but hasn't sent >>any email. >> >> >>I have tried doing that, but after entering the details into my yahoo email >>id, its not allowing me to press enter, due to yahoo security. >> >> >>Can you shared your method ? >> >>Warm Regards >>Ankur Aggarwal >>91-8010614628 >>Analyst >>Mckinsey Knowledge Center >>Mckinsey & Co. >> >> >> >>________________________________ >> From: "mohan.pande...@gmail.com" <mohan.pande...@gmail.com> >>To: excel-macros@googlegroups.com >>Sent: Friday, 4 January 2013 12:06 AM >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >> >>Yes I already did it. Need some time if you really want it but I have just >>log in the account not sure about sending email using vba. >>Sent from BlackBerry® on Airtel >>________________________________ >> >>From: ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> >>Sender: excel-macros@googlegroups.com >>Date: Fri, 4 Jan 2013 02:07:47 +0800 (SGT) >>To: Lalit Mohan Pandey<mohan.pande...@gmail.com>; >>excel-macros@googlegroups.com<excel-macros@googlegroups.com> >>ReplyTo: excel-macros@googlegroups.com >>Subject: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel >>vba >> >> >>Hi Lalit, >> >> >>Thanks for the reply. >> >> >>Below link is not working and the file they have provided is not functioning. >> >> >>Even I have googled a lot, and it seems due to security concerns, gmail or >>yahoo servers are not allowing to access there web sites using a macro. >> >> >>Please let me know if you have tried the same at ur end ? >> >>Regards >>Ankur >> >> >>From: Lalit Mohan Pandey <mohan.pande...@gmail.com> >>To: excel-macros@googlegroups.com >>Cc: ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> >>Sent: Thursday, 3 January 2013 7:31 PM >>Subject: Re: Login to gmail/yahoo and send email using excel vba >> >> >>Hi Ankur, >> >> >>You can find an example to login in gmail account using vba at below >>mentioned link:- >> >> >>http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ >> >> >> >>let us know for further assistance. >> >> >>Regards, >>Lalit Mohan >> >>On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur aggarwal wrote: >>Hi Team, >>> >>> >>>I wanted to run an excel macro which can automate yahoo/gmail process using >>>excel vba. Upon clicking of the button, it will send an email from a web >>>browser ( IE ) using yahoo/gmail to a given email id. >>> >>> >>>Can anybody please help in doing that ? I have written a macro which >>>actually opens IE and g mail web site, then I have created the HTML object >>>and its going to gmail website. But I am unable to proceed further (attach >>>file and send it to recipient ). >>> >>>Thanks in Advance ! >>> >>> >>>Warm Regards >> >> -- >>Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >>-- >>Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> >> -- >>Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >>-- >>Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> >> >> -- >>Join official Facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get quick attention or may not be answered. >>2) Don't post a question in the thread of another member. >>3) Don't post questions regarding breaking or bypassing any security measure. >>4) Acknowledge the responses you receive, good or bad. >>5) Jobs posting is not allowed. >>6) Sharing copyrighted material and their links is not allowed. >> >>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >>Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >-- >Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
