Re: $$Excel-Macros$$ PDF attachment in Excel Cell
How is it working ?, Also the code is password protected, can you please share the password ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; amar takale amartak...@gmail.com Sent: Tuesday, 26 February 2013 9:40 AM Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell Dear Amar, Yes it is possible with hyperlink just give the right url and save it. Pl see the attached sheet. Warm Regards, Gawli Anil. On Mon, Feb 25, 2013 at 7:28 PM, Anil B ank.bira...@gmail.com wrote: listen for this one to attach the PDF Files u just need to hyperlink the file from desktop or file thats it u got the solution when u click it opens the file. Thanks, Anil On Mon, Feb 25, 2013 at 7:28 PM, Anil B ank.bira...@gmail.com wrote: Hi dude, On Mon, Feb 25, 2013 at 7:23 PM, amar takale amartak...@gmail.com wrote: Dear All Experts, Discuss to all about PDF attachment in Excel Cell Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Re: $$Excel-Macros$$ PDF attachment in Excel Cell
Hi Anil, VBA code is password protected. Also, I am interested to know, how this is possible, can you briefly explain, how you did the same. Thanks ! Warm Regards Ankur Aggarwal Analyst From: अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; ankur9_aggarwa...@yahoo.co.in Sent: Tuesday, 26 February 2013 11:52 AM Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell Dear Ankur, Whr u find password protected. the workbook which i have provided is not protected. My be the url of the first cell of that icon will be not available, because the url is from my desktop that's why. Warm Regards, Gawli Anil. On Tue, Feb 26, 2013 at 11:47 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: How is it working ?, Also the code is password protected, can you please share the password ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; amar takale amartak...@gmail.com Sent: Tuesday, 26 February 2013 9:40 AM Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell Dear Amar, Yes it is possible with hyperlink just give the right url and save it. Pl see the attached sheet. Warm Regards, Gawli Anil. On Mon, Feb 25, 2013 at 7:28 PM, Anil B ank.bira...@gmail.com wrote: listen for this one to attach the PDF Files u just need to hyperlink the file from desktop or file thats it u got the solution when u click it opens the file. Thanks, Anil On Mon, Feb 25, 2013 at 7:28 PM, Anil B ank.bira...@gmail.com wrote: Hi dude, On Mon, Feb 25, 2013 at 7:23 PM, amar takale amartak...@gmail.com wrote: Dear All Experts, Discuss to all about PDF attachment in Excel Cell Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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
$$Excel-Macros$$ Login to gmail/yahoo and send email using excel vba
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.
$$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.
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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
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.comexcel-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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
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 egto 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.comexcel-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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Apologies for replying late, was stuck in between an important work. Yes I googled the same, what I understood from Microsoft people and the website, is that problem of organizational chart does exist in excel 2003 and same has been rectified in excel 2007 or later versions. Now, since our client doesn't have xcel 2007 and they don't want to embed any add- in, creation of dynamic organization chart is difficult to implement. I have shared the sample excel file Example.xls along with a macro in one of my earlier mail. Thanks for the help so far. Much appreciated ! Warm Regards Ankur Aggarwal 91-8010614628 Analyst From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Wednesday, 7 November 2012 8:16 PM Subject: Re: $$Excel-Macros$$ Organization Chart can you send me your file? I need to know what type of object you're using for the Org Chart. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: Paul Schreiner schreiner_p...@att.net Sent: Wed, November 7, 2012 1:21:01 AM Subject: Re: $$Excel-Macros$$ Organization Chart Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node. Can you please recheck ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:10 PM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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
Re: $$Excel-Macros$$ Organization Chart
Thanks for sharing the thread Rajan, but unfortunately code doesn't work in Excel 2003 and my client is using excel 2003. Do you have any alternative ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:49 PM Subject: RE: $$Excel-Macros$$ Organization Chart Please have a look here http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-applications-smart-art.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 06 November 2012 7:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Organization Chart I also Googled Excel vba Org Chart and received 189,000 hits. Perhaps someone else has already done this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From:Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From:ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From:ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 (1120+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Thanks for the reply. Your method of double clicking and recording the macro works well for excel 2007, but its not working for excel 2003, reason being we not even getting the pop up for converting it into shape in 2003. What can be other alternative. Also I have googled but couldn't find any relevant info on the web. Warm Regards Ankur Aggarwal Analyst From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:21 PM Subject: Re: $$Excel-Macros$$ Organization Chart I also Googled Excel vba Org Chart and received 189,000 hits. Perhaps someone else has already done this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node. Can you please recheck ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:10 PM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 (1120
$$Excel-Macros$$ Organization Chart
Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Example.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ switch on anf off calculation
Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Unique Name Query
That was a very useful excel function. Thanks for sharing this. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Haseeb A haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 10 July 2012 4:37 AM Subject: $$Excel-Macros$$ Re: Unique Name Query Hello Karan, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100,IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),) If you need Unique Names in Ascending Order, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(0,IF(A$2:A$100,COUNTIF(A$2:A$100,A$2:A$100),)-SUM(COUNTIF(A$2:A$100,C$1:C1)),0)),) Note: You must have something for IF's false argument ie. , any text or a Big number like 2^21, 9E+300 etc.. If you need Descending Order, change to These formulas will work even if you have blank cells in the range. See the sample file. Regards, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Totally agreed. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Divaker Pandey divake...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 28 June 2012 8:44 PM Subject: Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire) Hi Noorain, I think job related to excel vba mail should not be banned. 1. it will help to user to know what is in current demand in excel related job. 2. it will encourage to learn and solve more excels quiz. 3. in last each enhanced skill is used to get better job options. Regards. Divaker On Thu, Jun 28, 2012 at 7:29 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Jitu, As per Forum rule, Job related mail has been banned. Brother take care in future. On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh jeete2...@gmail.com wrote: -- Forwarded message -- From: RJT Compuquest so...@rjtcindia.com Date: Thu, Jun 28, 2012 at 1:26 PM Subject: MIS executive opening with Aricent Technologies (Contact to Hire) To: jeete2...@gmail.com The sender of this email is registered with Naukri.com as RJT Compuquest Experience required for the Job: 2 - 3 years Job Location: Gurgaon Apply Now(Send your Naukri profile to express interest to the recruiter) Dear Candidate, Hello, Greetings of the Day!!! We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon (Working on a payroll of RJT) About Aricent(CLient): Our Client is a global innovation, technology and services company focused exclusively on communications. Its unique engagement model blends strategy, design, technology and engineering services, delivering exceptional value across each phase of the product and service lifecycle. Together with its global innovation arm frog design, offers 40 years experience in delivering innovation and technology breakthroughs that have transformed entire industries. With more than 800 clients, 9500 employees in 19 countries,more than 100 industry awards. It is uniquely positioned to help organizations conceive and commercialize innovative solutions. Please fill this below details: Currrent CTC: Expected CTC: Notice Period: DOB: Roles Responsbilities: Expertise in MS-Excel, MS-Power Point, MS-Word MS- Access Good analytical management skills Ability to relate various data sources for comparing/contrasting Ability to interpret requirements be self driven Preparing presenting appropriate reports as when required Maintain data pertaining to all departments - OM, Finance Accounts, HR Admin, Sales Service, Education Handling different projects assignment as when required Qualification: Any Graduate Location: Gurgaon Please forward your updated resume and also refer your friend or colleague who are interested to change. Awaiting your prompt reply. Thanks Regards Sonia Gupta Is this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as RJT Compuquest (gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR, GURGAON, Haryana - 122001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.com 2. You can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact complia...@naukri.com for advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members
$$Excel-Macros$$ Interesteing Problem : - Morefunc Addin - Why it could not be embedded like in Excel 2003?
Hi all, Good Morning. There is an exciting challenge ahead of me. Has any one worked on Morefunc Addin ? Mconcat fn is used as an add - in in excel 2003. There is a Big 200 MB Model, where in one of the worksheets, Mconcat fn ( utility of the add-in) is used. This add-in can easily be embedded in excel 2003, means when we are transferring the file from one system to another, u don't explicitly need to install add in again go the system. But issue is when we are moving this model from 2003 to 2010 version. We can't embed the same and each time we need to explicitly install the add - in into every system. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved. Need particulaly help in 2 things :- 1. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved according to me. Still if someone knows the trick, please let me know. 2. If anyone has used Mconcat function. ? What does it do and whats the way around, can we replace mconcat function using the addi-n by complex excel formula ? Please help ! Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, A).End(xlUp).Row sh.Range(I i).GoalSeek Goal:=sh.Range(A i).Value, ChangingCell:=sh.Range(E i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm RegardsAnkur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, A).End(xlUp).Row sh.Range(I i).GoalSeek Goal:=sh.Range(A i).Value, ChangingCell:=sh.Range(E i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm RegardsAnkur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Hi Rajan, formula is in B6, B5 is the set value, we need to predict B4. We will get the refreshed value in cell B5. ( Means this value is coming again and again fro the DB ). Please let me know if iteration will help. ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 5:55 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula I think it can be done by enabling iteration in formula .. what result you want in b6 or what condition you want to apply in calculation? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 2:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From:NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From:NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, A).End(xlUp).Row sh.Range(I i).GoalSeek Goal:=sh.Range(A i).Value, ChangingCell:=sh.Range(E i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Sure Rajan. Cell B5 contains the NPV value which can also be calculated using the formula in cell B6. It's like we know the NPV value, we wanted to back calculate Discount rate which is used in calculating the NPV value. Now, this can be easily done manually through a simple goal seek. But problem is, since NPV value ( cell B5 ) keeps on changing again and again, one has to manually do goal seek again and again or write a macro which will change set value in goal seek to cell B5. But now the client doesn't want us to use the macro. Can excel formula do the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 7:38 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula Can you explain how b5 is related to the formula in b6? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 6:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Hi Rajan, formula is in B6, B5 is the set value, we need to predict B4. We will get the refreshed value in cell B5. ( Means this value is coming again and again fro the DB ). Please let me know if iteration will help. ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From:Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 5:55 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula I think it can be done by enabling iteration in formula .. what result you want in b6 or what condition you want to apply in calculation? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 2:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From:NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From:NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, A).End(xlUp).Row sh.Range(I i).GoalSeek Goal:=sh.Range(A i).Value, ChangingCell:=sh.Range(E i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ Introduce Yourself !!
Hi All, This is Ankur Aggarwal, working as an analyst in Mckinsey Knowledge Center from 2 years. I am looking forward to the group and the learning, will also try to answer the queries if anybody has on excel, assess, predicative modelling. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Nagendra Modupalli naga14...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, 20 June 2012 9:53 AM Subject: Re: $$Excel-Macros$$ Introduce Yourself !! Dear All, My self Nagendra M and 28 years old. am basically from Andhra Pradesh.Working in Bangalore as a Finance Analyst fast 7years. I like very much Excel and this group as well...Thanks you so much knowledge sharing and helping other's ThanksRegards Nagendra.M Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Automating a goal seek using an excel formula
Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com