Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread ANKUR AGGARWAL
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

$$Excel-Macros$$ Login to gmail/yahoo and send email using excel vba

2013-01-03 Thread ANKUR AGGARWAL
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

$$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-03 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-03 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-03 Thread ANKUR AGGARWAL
: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

Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-03 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Organization Chart

2012-11-11 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Organization Chart

2012-11-06 Thread ANKUR AGGARWAL
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

$$Excel-Macros$$ Organization Chart

2012-11-05 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ switch on anf off calculation

2012-07-10 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Re: Unique Name Query

2012-07-09 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)

2012-06-28 Thread ANKUR AGGARWAL
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

$$Excel-Macros$$ Interesteing Problem : - Morefunc Addin - Why it could not be embedded like in Excel 2003?

2012-06-24 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

2012-06-21 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

2012-06-21 Thread ANKUR AGGARWAL
. 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

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

2012-06-21 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

2012-06-21 Thread ANKUR AGGARWAL
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

Re: $$Excel-Macros$$ Introduce Yourself !!

2012-06-20 Thread ANKUR AGGARWAL
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

$$Excel-Macros$$ Automating a goal seek using an excel formula

2012-06-20 Thread ANKUR AGGARWAL
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