RE: $$Excel-Macros$$ Automation in excel
Waiting for reply On Oct 10, 2012 11:52 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Actually I don't know about the coding in vba where I can learn coding for vba. I know only record macro. I want to do coding in my way. What I want I get it from my data. Thanks Manoj On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Just a quick Example :* * * ***1) You are an analyst in Vodafone, you daily receive lot of Customer application form on your mail in Excel Sheet, and you want to know -* ***a. how many are from Gurgaon, Delhi,Noida ??* ***b. How many are Corporate Connection ?* ***c. Count of different Plans sold?* ***d. And many more questions* * * *What is the first things comes in mind.. how to get forms data in table format to get answers of all questions?* * * ***2) You have data in Table format , you want to send Thank you note to every customer by mail.* ***a. How much time will you take to convert that data in a particular format?* ***b. Will you send every mail one by one ?* * * * So , automation is a process to save time and manpower to accomplish any task [in office], when you will learn Automation in Excel , you will be able to do this job on a single Click **J*** * * *How this works in excel?* *Computer programming skills required to automate excel, Visual basic for application (VBA) comes with Excel (office), by which we can manipulate excel objects programmatically.* * * *How will you learn?* *Lot of website, forums, online classes are available where you can get the sound knowledge about Excel VBA , some of them are below :* * * *This Forum as well **J*** *www.ExcelFox.Com* *www.excelpoweruser.wordpress.com* *http://excelvbaprogramming.wordpress.com/*http://excelvbaprogramming.wordpress.com/ * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar *Sent:* 10 October 2012 10:48 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Automation in excel ** ** Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- 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. -- 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. -- 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
RE: $$Excel-Macros$$ Automation in excel
Download this book. Excel 2003 Power Programming with VBA By j-walk You can learn from basic to intermediate knowledge of VBA from this book.. every chapter written in a very explanatory way, you will really enjoy reading this book. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manoj Kumar Sent: 13 October 2012 8:38 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Automation in excel Waiting for reply On Oct 10, 2012 11:52 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Actually I don't know about the coding in vba where I can learn coding for vba. I know only record macro. I want to do coding in my way. What I want I get it from my data. Thanks Manoj On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Just a quick Example : 1) You are an analyst in Vodafone, you daily receive lot of Customer application form on your mail in Excel Sheet, and you want to know - a. how many are from Gurgaon, Delhi,Noida ?? b. How many are Corporate Connection ? c. Count of different Plans sold? d. And many more questions What is the first things comes in mind.. how to get forms data in table format to get answers of all questions? 2) You have data in Table format , you want to send Thank you note to every customer by mail. a. How much time will you take to convert that data in a particular format? b. Will you send every mail one by one ? So , automation is a process to save time and manpower to accomplish any task [in office], when you will learn Automation in Excel , you will be able to do this job on a single Click J How this works in excel? Computer programming skills required to automate excel, Visual basic for application (VBA) comes with Excel (office), by which we can manipulate excel objects programmatically. How will you learn? Lot of website, forums, online classes are available where you can get the sound knowledge about Excel VBA , some of them are below : This Forum as well J www.ExcelFox.Com www.excelpoweruser.wordpress.com http://excelvbaprogramming.wordpress.com/ http://excelvbaprogramming.wordpress.com/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manoj Kumar Sent: 10 October 2012 10:48 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Automation in excel Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- 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. -- 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
RE: $$Excel-Macros$$ Automation in excel
Just a quick Example : 1) You are an analyst in Vodafone, you daily receive lot of Customer application form on your mail in Excel Sheet, and you want to know - a. how many are from Gurgaon, Delhi,Noida ?? b. How many are Corporate Connection ? c. Count of different Plans sold? d. And many more questions What is the first things comes in mind.. how to get forms data in table format to get answers of all questions? 2) You have data in Table format , you want to send Thank you note to every customer by mail. a. How much time will you take to convert that data in a particular format? b. Will you send every mail one by one ? So , automation is a process to save time and manpower to accomplish any task [in office], when you will learn Automation in Excel , you will be able to do this job on a single Click J How this works in excel? Computer programming skills required to automate excel, Visual basic for application (VBA) comes with Excel (office), by which we can manipulate excel objects programmatically. How will you learn? Lot of website, forums, online classes are available where you can get the sound knowledge about Excel VBA , some of them are below : This Forum as well J www.ExcelFox.Com www.excelpoweruser.wordpress.com http://excelvbaprogramming.wordpress.com/ http://excelvbaprogramming.wordpress.com/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manoj Kumar Sent: 10 October 2012 10:48 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Automation in excel Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- 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. -- 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.
RE: $$Excel-Macros$$ Automation in excel
Actually I don't know about the coding in vba where I can learn coding for vba. I know only record macro. I want to do coding in my way. What I want I get it from my data. Thanks Manoj On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Just a quick Example :* * * ***1) You are an analyst in Vodafone, you daily receive lot of Customer application form on your mail in Excel Sheet, and you want to know -* ***a. how many are from Gurgaon, Delhi,Noida ??* ***b. How many are Corporate Connection ?* ***c. Count of different Plans sold?* ***d. And many more questions* * * *What is the first things comes in mind.. how to get forms data in table format to get answers of all questions?* * * ***2) You have data in Table format , you want to send Thank you note to every customer by mail.* ***a. How much time will you take to convert that data in a particular format?* ***b. Will you send every mail one by one ?* * * * So , automation is a process to save time and manpower to accomplish any task [in office], when you will learn Automation in Excel , you will be able to do this job on a single Click **J*** * * *How this works in excel?* *Computer programming skills required to automate excel, Visual basic for application (VBA) comes with Excel (office), by which we can manipulate excel objects programmatically.* * * *How will you learn?* *Lot of website, forums, online classes are available where you can get the sound knowledge about Excel VBA , some of them are below :* * * *This Forum as well **J*** *www.ExcelFox.Com* *www.excelpoweruser.wordpress.com* *http://excelvbaprogramming.wordpress.com/*http://excelvbaprogramming.wordpress.com/ * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar *Sent:* 10 October 2012 10:48 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Automation in excel ** ** Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- 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. -- 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. -- 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
