$$Excel-Macros$$ sum base on condition
Hi All, Can you help me on this example. I’m looking for excel function that will be summarized what I have to buy and I’ve bought already. I have table with requirements. On this base I’m ordering components from different suppliers. For my budget I need to know how much I’ve already paid and how much I’m going to pay. I need to have a function that will tell me if e.g. row order I have order number it should be count as order already placed if not should be count as “not order”. Thanks for help Pawel -- 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. Book2.xlsx Description: Binary data
RE: $$Excel-Macros$$ Vlookup Book
Dear Noorain, Could you please share the Vlookup book if it is prepared at your end? Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: 02 November 2012 16:46 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Vlookup Book Dear Noorain, Are you back? Could you please share a book to be written on vlookup? Best Regards, Amit From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of noorain.ans...@gmail.commailto:noorain.ans...@gmail.com Sent: 29 October 2012 17:07 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Book Dear Amit, Currently i am out of station. Will share it shortly Sent from BlackBerry(r) on Airtel From: Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com Sender: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Date: Mon, 29 Oct 2012 14:25:27 +0530 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Book Dear Noorain, Few days back you were referring a book to be written on vlookup. If you have completed, could you please share the same with the Group? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto: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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Disclaimer: This
Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.
Thank you sir. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 8 Nov 2012 11:27:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajersand...@gmail.com wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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.
RE: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.
Dear Excel gurus, How to use this tutorials? Nothing has been provided in this to make excel dashboards. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 08 November 2012 11:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajersand...@gmail.com wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http://www.noorainansari.com http://noorainansari.com http://www.noorainansari.com http://www.excelvbaclinic.blogspot.com http://excelvbaclinic.com http://www.excelvbaclinic.blogspot.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. 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.
Re: $$Excel-Macros$$ Vlookup Book
Dear Amit, I am still committed on my words. But I need some more time to complete it perfection and after completing it I will definitely share it with group without any further reminder. Kindly don't mark any mail to my official ID. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Thu, Nov 8, 2012 at 4:31 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Noorain, ** ** Could you please share the Vlookup book if it is prepared at your end? ** ** Best Regards, Amit ** ** *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com] *Sent:* 02 November 2012 16:46 *To:* 'excel-macros@googlegroups.com' *Subject:* RE: $$Excel-Macros$$ Vlookup Book ** ** Dear Noorain, ** ** Are you back? ** ** Could you please share a book to be written on vlookup? ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [ mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com] *On Behalf Of *noorain.ans...@gmail.com *Sent:* 29 October 2012 17:07 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Vlookup Book ** ** Dear Amit, Currently i am out of station. Will share it shortly Sent from BlackBerry® on Airtel -- *From: *Amit Desai (MERU) amit.de...@merucabs.com *Sender: *excel-macros@googlegroups.com *Date: *Mon, 29 Oct 2012 14:25:27 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Vlookup Book ** ** Dear Noorain, ** ** Few days back you were referring a book to be written on vlookup. ** ** If you have completed, could you please share the same with the Group? ** ** Best Regards, Amit ** ** ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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
Re: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.
Hi Sandeep, See below link: http://chandoo.org/wp/excel-dashboards/ Regards, Kuldeep Singh On Thu, Nov 8, 2012 at 4:45 PM, Sandeep Chhajer chhajersand...@gmail.comwrote: Dear Excel gurus, How to use this tutorials? Nothing has been provided in this to make excel dashboards. ** ** *Thank you Regards Sandeep Kumar Chhajer.* * * ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 08 November 2012 11:28 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. ** ** Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajersand...@gmail.com wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.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. 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
$$Excel-Macros$$ Re: Chart stuff
Yes On Thursday, 8 November 2012 00:33:40 UTC+5:30, santosh wrote: Hello, Can the graph in the attchment be modified as per the below table. If so would request you to please help me with this Group110% Group220% Group330% Group415% Group525% Total100% Regards Santosh santoshkum...@gmail.com javascript: -- 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.
RE: $$Excel-Macros$$ Vlookup Book
Sure... thanks a lot. Best Regards, Amit From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: 08 November 2012 16:47 To: Amit Desai (MERU) Cc: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Book Dear Amit, I am still committed on my words. But I need some more time to complete it perfection and after completing it I will definitely share it with group without any further reminder. Kindly don't mark any mail to my official ID. -- With Regards, Noorain Ansari http://http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http://http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Thu, Nov 8, 2012 at 4:31 PM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: Dear Noorain, Could you please share the Vlookup book if it is prepared at your end? Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.commailto:amit.de...@merucabs.com] Sent: 02 November 2012 16:46 To: 'excel-macros@googlegroups.commailto:excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Vlookup Book Dear Noorain, Are you back? Could you please share a book to be written on vlookup? Best Regards, Amit From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of noorain.ans...@gmail.commailto:noorain.ans...@gmail.com Sent: 29 October 2012 17:07 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Book Dear Amit, Currently i am out of station. Will share it shortly Sent from BlackBerry(r) on Airtel From: Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com Sender: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Date: Mon, 29 Oct 2012 14:25:27 +0530 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Book Dear Noorain, Few days back you were referring a book to be written on vlookup. If you have completed, could you please share the same with the Group? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto: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)
$$Excel-Macros$$ Picture are not showing help req.
Dear Experts, kindly see the atached snaps, which are not showing. kindly convert -- 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. image001.emz Description: Binary data image003.emz Description: Binary data
RE: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup
You can use this one Function MLOOKUP(TableArray As Range, ByVal LookupVal, LookupRange As Range, _ Optional ByVal NthMatch As Long) ' Author: Krishnakumar @ ExcelFox.com ‘Modified by :- Rajan Verma @ ExcelPoweruser.wordpress.com If Not TypeOf TableArray Is Range Then MLOOKUP = CVErr(2042) Exit Function End If If Not TypeOf LookupRange Is Range Then MLOOKUP = CVErr(2042) Exit Function End If If TableArray.Rows.Count LookupRange.Rows.Count Then MLOOKUP = CVErr(2042) Exit Function End If If TableArray.Columns.Count LookupRange.Columns.Count Then MLOOKUP = CVErr(2042) Exit Function End If Dim LV_Cnt As Long 'Count Loookup Value Dim KA1, KA2 Dim r As Long, c As Long Dim fFoundNoAs Long Dim n As Long Dim strLval As String If IsNumeric(LookupVal) Then LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , LookupVal )) fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0)) ElseIf IsDate(LookupVal) Then LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , CLng(LookupVal) )) fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0)) Else strLval = LookupVal LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , strLval )) fFoundNo = Evaluate(match( strLval , LookupRange.Address(, , , 1) ,0)) End If If NthMatch 0 Then If LV_Cnt = 0 Or NthMatch LV_Cnt Then MLOOKUP = CVErr(2042) Exit Function End If End If KA1 = TableArray: KA2 = LookupRange For r = fFoundNo To UBound(KA1, 1) For c = 1 To UBound(KA1, 2) If LCase$(KA2(r, c)) = LCase$(LookupVal) Then If NthMatch Then n = n + 1 If n = NthMatch Then MLOOKUP = KA1(r, c) Exit Function End If Else MLOOKUP = MLOOKUP , KA1(r, c) End If End If Next Next MLOOKUP = Mid$(MLOOKUP, 2) End Function Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 08 November 2012 4:25 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup Hi Mr.Rajan Thanks to sharing useful link of Mlookup but there is a problem in sheet that the function working only same worksheet, if i link to another sheet the function is not working. Kindly reply for this solution. Thanks regards Ashish Bhalara On Thu, Oct 25, 2012 at 8:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Download the file from here http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ Thanks Rajan. On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote: Hi xlts, Please help me, on how to get the all the associated items In the range where it as more than 1 lookupvalue. Thanks, Saravanan -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . -- Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- 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
Re: $$Excel-Macros$$ Required tutorials to learn Basics of Dashboards.
Dear Sandeep, Please use below link How to create Excel Dashboards http://www.contextures.com/excel-dashboards.html http://www.exceldashboardwidgets.com/ On Thu, Nov 8, 2012 at 4:52 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Sandeep, See below link: http://chandoo.org/wp/excel-dashboards/ Regards, Kuldeep Singh On Thu, Nov 8, 2012 at 4:45 PM, Sandeep Chhajer chhajersand...@gmail.comwrote: Dear Excel gurus, How to use this tutorials? Nothing has been provided in this to make excel dashboards. ** ** *Thank you Regards Sandeep Kumar Chhajer.* * * ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 08 November 2012 11:28 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. ** ** Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajersand...@gmail.com wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.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. 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
RE: $$Excel-Macros$$ Picture are not showing help req.
Is it picture format ? If it is you need a software to open those file.. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan Sent: 08 November 2012 5:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Picture are not showing help req. Dear Experts, kindly see the atached snaps, which are not showing. kindly convert -- 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.
$$Excel-Macros$$ run macro from another file
Hi All, I'd like to ask you for help. I'd like to run macro from different file. So I have master file where I have all data, this data a copied to another file and after that macro need to be run. issue is: each day name of the file is different so I can use stable one like Application.Run 'aaa.xls'!macro each day can be different so I can have: Application.Run 'day1.xls'!macro Application.Run 'day2.xls'!macro Application.Run 'day3.xls'!macro . I need solution to be able to open file and run specific macro in this file. Any solution please Regards, Pawel -- 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.
Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup
Dear Rajan, Kindly tell Exactly what changes or modifications you have made to the code ! On Thu, Nov 8, 2012 at 6:31 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *You can use this one * *Function MLOOKUP(TableArray As Range, ByVal LookupVal, LookupRange As Range, _* *Optional ByVal NthMatch As Long)* * * *' Author: Krishnakumar @ ExcelFox.com* *‘Modified by :- Rajan Verma @ ExcelPoweruser.wordpress.com* * * * * *If Not TypeOf TableArray Is Range Then* *MLOOKUP = CVErr(2042)* *Exit Function* *End If* *If Not TypeOf LookupRange Is Range Then* *MLOOKUP = CVErr(2042)* *Exit Function* *End If* *If TableArray.Rows.Count LookupRange.Rows.Count Then* *MLOOKUP = CVErr(2042)* *Exit Function* *End If* *If TableArray.Columns.Count LookupRange.Columns.Count Then* *MLOOKUP = CVErr(2042)* *Exit Function* *End If* * * *Dim LV_Cnt As Long 'Count Loookup Value* *Dim KA1, KA2* *Dim r As Long, c As Long* *Dim fFoundNoAs Long* *Dim n As Long* *Dim strLval As String* * * *If IsNumeric(LookupVal) Then* *LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , LookupVal ))* *fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0))* *ElseIf IsDate(LookupVal) Then* *LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , CLng(LookupVal) ))* *fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0))* *Else* *strLval = LookupVal * *LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , strLval ))* *fFoundNo = Evaluate(match( strLval , LookupRange.Address(, , , 1) ,0))* *End If* * * *If NthMatch 0 Then* *If LV_Cnt = 0 Or NthMatch LV_Cnt Then* *MLOOKUP = CVErr(2042)* *Exit Function* *End If* *End If* * * * * *KA1 = TableArray: KA2 = LookupRange* * * *For r = fFoundNo To UBound(KA1, 1)* *For c = 1 To UBound(KA1, 2)* *If LCase$(KA2(r, c)) = LCase$(LookupVal) Then* *If NthMatch Then* *n = n + 1* *If n = NthMatch Then* *MLOOKUP = KA1(r, c)* *Exit Function* *End If* *Else* *MLOOKUP = MLOOKUP , KA1(r, c)* *End If* *End If* *Next* *Next* *MLOOKUP = Mid$(MLOOKUP, 2)* *End Function* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara *Sent:* 08 November 2012 4:25 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup ** ** Hi Mr.Rajan Thanks to sharing useful link of Mlookup but there is a problem in sheet that the function working only same worksheet, if i link to another sheet the function is not working. Kindly reply for this solution. ** ** Thanks regards Ashish Bhalara On Thu, Oct 25, 2012 at 8:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi ** ** Download the file from here ** ** http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ ** ** Thanks Rajan. On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote: Hi xlts, Please help me, on how to get the all the associated items In the range where it as more than 1 lookupvalue. Thanks, Saravanan -- 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. ** ** -- Thanks regards. ** ** Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary.
RE: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup
I have just Change LookupRange.Address to LookupRange.Address(, , , 1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kanwaljit Singh Sent: 08 November 2012 7:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup Dear Rajan, Kindly tell Exactly what changes or modifications you have made to the code ! On Thu, Nov 8, 2012 at 6:31 PM, Rajan_Verma rajanverma1...@gmail.com wrote: You can use this one Function MLOOKUP(TableArray As Range, ByVal LookupVal, LookupRange As Range, _ Optional ByVal NthMatch As Long) ' Author: Krishnakumar @ ExcelFox.com ‘Modified by :- Rajan Verma @ ExcelPoweruser.wordpress.com If Not TypeOf TableArray Is Range Then MLOOKUP = CVErr(2042) Exit Function End If If Not TypeOf LookupRange Is Range Then MLOOKUP = CVErr(2042) Exit Function End If If TableArray.Rows.Count LookupRange.Rows.Count Then MLOOKUP = CVErr(2042) Exit Function End If If TableArray.Columns.Count LookupRange.Columns.Count Then MLOOKUP = CVErr(2042) Exit Function End If Dim LV_Cnt As Long 'Count Loookup Value Dim KA1, KA2 Dim r As Long, c As Long Dim fFoundNoAs Long Dim n As Long Dim strLval As String If IsNumeric(LookupVal) Then LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , LookupVal )) fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0)) ElseIf IsDate(LookupVal) Then LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , CLng(LookupVal) )) fFoundNo = Evaluate(match( CLng(LookupVal) , LookupRange.Address(, , , 1) ,0)) Else strLval = LookupVal LV_Cnt = Evaluate(countif( LookupRange.Address(, , , 1) , strLval )) fFoundNo = Evaluate(match( strLval , LookupRange.Address(, , , 1) ,0)) End If If NthMatch 0 Then If LV_Cnt = 0 Or NthMatch LV_Cnt Then MLOOKUP = CVErr(2042) Exit Function End If End If KA1 = TableArray: KA2 = LookupRange For r = fFoundNo To UBound(KA1, 1) For c = 1 To UBound(KA1, 2) If LCase$(KA2(r, c)) = LCase$(LookupVal) Then If NthMatch Then n = n + 1 If n = NthMatch Then MLOOKUP = KA1(r, c) Exit Function End If Else MLOOKUP = MLOOKUP , KA1(r, c) End If End If Next Next MLOOKUP = Mid$(MLOOKUP, 2) End Function Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 08 November 2012 4:25 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup Hi Mr.Rajan Thanks to sharing useful link of Mlookup but there is a problem in sheet that the function working only same worksheet, if i link to another sheet the function is not working. Kindly reply for this solution. Thanks regards Ashish Bhalara On Thu, Oct 25, 2012 at 8:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Download the file from here http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ Thanks Rajan. On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote: Hi xlts, Please help me, on how to get the all the associated items In the range where it as more than 1 lookupvalue. Thanks, Saravanan -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . -- Thanks regards. Ashish
Re: $$Excel-Macros$$ run macro from another file
ok found it http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=210201 From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, November 8, 2012 1:34 PM Subject: $$Excel-Macros$$ run macro from another file Hi All, I'd like to ask you for help. I'd like to run macro from different file. So I have master file where I have all data, this data a copied to another file and after that macro need to be run. issue is: each day name of the file is different so I can use stable one like Application.Run 'aaa.xls'!macro each day can be different so I can have: Application.Run 'day1.xls'!macro Application.Run 'day2.xls'!macro Application.Run 'day3.xls'!macro . I need solution to be able to open file and run specific macro in this file. Any solution please Regards, Pawel-- 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.
$$Excel-Macros$$ Accoount payable excel templates
Hi friends, Please share the excel template of accounts payable if any one of u is having. basically i am planning to build up a template on accounts payable data in excel for forecasting and analysis. and need your experts advise. Please do share if any of you are having such stuff. Thanks in Advance. -- -- Thanks Regards, Rajasekhar.P -- 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.
RE: $$Excel-Macros$$ Accoount payable excel templates
May be B Sharma Can help you on this forum. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajasekhar Praharaju Sent: 08 November 2012 9:11 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Accoount payable excel templates Hi friends, Please share the excel template of accounts payable if any one of u is having. basically i am planning to build up a template on accounts payable data in excel for forecasting and analysis. and need your experts advise. Please do share if any of you are having such stuff. Thanks in Advance. -- -- Thanks Regards, Rajasekhar.P -- 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.
$$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)
Dear Noorain Please share, what is magical in this template thanks -Ayush Jain On Thursday, 8 November 2012 17:12:23 UTC+5:30, NOORAIN ANSARI wrote: Dear Group, Please find attached template and double click on it. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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.
Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.
Hi Sandeep, You can visit www.dashboardspy.com or chandoo.org for learning the dashboards Noorain, I am not sure how the document that you shared will be helpful in learning dashboards. That attachment is specifically designed to guide Digital Dashboard function in IMMEX that may be some proprietary feature of some company. It does not at all teaches how to develop dashboard or give presentation in excel. Regards, Ayush Jain Group Manager On Thursday, 8 November 2012 16:40:45 UTC+5:30, sandeep chhajer wrote: Thank you sir. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: * NOORAIN ANSARI noorain...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Thu, 8 Nov 2012 11:27:38 +0530 *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajer...@gmail.com javascript:wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. 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
$$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.
Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these characters from the table so that they can not be view in the from and table should be clean from such unwanted characters. I takes much time to remove them manually as my table contains more than 2000 records. Please help me by providing some suitable vba code or any other method. I need your help for this. Thanks in advance. -- With regards, *MaNgEsH* -- 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. image.png
Re: $$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)
Dear Ayush, When we double click on the sheet, Text began to move one by one. It has created by help of power-point presentation. and call through Insert-Object. On Thu, Nov 8, 2012 at 9:38 PM, Ayush Jain jainayus...@gmail.com wrote: Dear Noorain Please share, what is magical in this template thanks -Ayush Jain On Thursday, 8 November 2012 17:12:23 UTC+5:30, NOORAIN ANSARI wrote: Dear Group, Please find attached template and double click on it. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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.
$$Excel-Macros$$ multiple sheet reference..
Hello brothers and sisters, first of all i want to convey my thanks to all for your great service on excel. Then i want to know how can i get multiple sheet (morethan 10) reference for vlookup.. please find the attachment of excel and advice the tric.. thanks in advance. Regards Jafna kuwait -- 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. lookup referece from multiple sheet.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help for Access 2007- How to remove unwanted characters from table.
Hi Mangesh, Can you plase share your workbook with us ? Regards Prince On Friday, November 9, 2012 12:09:18 AM UTC+5:30, Mangesh wrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these characters from the table so that they can not be view in the from and table should be clean from such unwanted characters. I takes much time to remove them manually as my table contains more than 2000 records. Please help me by providing some suitable vba code or any other method. I need your help for this. Thanks in advance. -- With regards, *MaNgEsH* -- 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.
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Vabz, Here with enclosing the file with VBA script which i'm currently using (it is working for manual stuff but fails when data linked to application)... the Data what i'm talking about is linked to application and it will get refreshed each second (Refer Yahoo-finance for more info on how the data keeps changin in each seconds). With your current code, it is sending e-mail on every refresh without validating the Value condition (Using If condition to get an Value in the enclosed file). Can you help me with Validating option ?? Cheers JP. On Thu, Nov 8, 2012 at 5:03 PM, VBA VABZ v...@vabs.in wrote: hi Happy to know that things are working after so much of struggle by you guyz. Add in teh begining Dim Fname as variant Before with statement add this line FName = ActiveWorkbook.Path \ ActiveWorkbook.Name Between with statement add this line .Attachments.Add FName Cheerz//Vabs On Thu, Nov 8, 2012 at 4:46 PM, veerendra vanam veerendra.va...@gmail.com wrote: Dear Sir, It's working fine but i need attached file also where give path adreess in that macro code On Wed, Nov 7, 2012 at 7:08 PM, Vabz v...@vabs.in wrote: Hi Veerendra PFA this is designed to send email every 30secs. You can change linez to send evry hours Cheers//Vabs On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail as no change in the Value (also e-mail has already been sent @ 9.10 AM !!) Thank you. JP On Tue, Nov 6, 2012 at 4:13 PM, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing
Re: $$Excel-Macros$$ Required Unique data with funtion
Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote: Hi Experts, Please solve this Query. Regards, Priyanka -- 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+ 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.
Re: $$Excel-Macros$$ Required Unique data with funtion
Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard eugene.bern...@gmail.comwrote: Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote: Hi Experts, Please solve this Query. Regards, Priyanka -- 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+ 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
Re: $$Excel-Macros$$ Required Unique data with funtion
How to achieve this thro' functions without manually sorting. Regards Eugene On Fri, Nov 9, 2012 at 11:56 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard eugene.bern...@gmail.comwrote: Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote: Hi Experts, Please solve this Query. Regards, Priyanka -- 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+ 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)
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hey, I'm on break for exam n doesn't have access to my PC/Lalptop. I'll be able to see in to this not before sun eve or monday. If sum one can help then would be great!! Cheerz Thanks::Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Jayaprakash S bhat.jayaprak...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 9 Nov 2012 11:03:17 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Hi Vabz, Here with enclosing the file with VBA script which i'm currently using (it is working for manual stuff but fails when data linked to application)... the Data what i'm talking about is linked to application and it will get refreshed each second (Refer Yahoo-finance for more info on how the data keeps changin in each seconds). With your current code, it is sending e-mail on every refresh without validating the Value condition (Using If condition to get an Value in the enclosed file). Can you help me with Validating option ?? Cheers JP. On Thu, Nov 8, 2012 at 5:03 PM, VBA VABZ v...@vabs.in wrote: hi Happy to know that things are working after so much of struggle by you guyz. Add in teh begining Dim Fname as variant Before with statement add this line FName = ActiveWorkbook.Path \ ActiveWorkbook.Name Between with statement add this line .Attachments.Add FName Cheerz//Vabs On Thu, Nov 8, 2012 at 4:46 PM, veerendra vanam veerendra.va...@gmail.com wrote: Dear Sir, It's working fine but i need attached file also where give path adreess in that macro code On Wed, Nov 7, 2012 at 7:08 PM, Vabz v...@vabs.in wrote: Hi Veerendra PFA this is designed to send email every 30secs. You can change linez to send evry hours Cheers//Vabs On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail as no change in the Value (also e-mail has already been sent @ 9.10 AM !!) Thank you. JP On Tue, Nov 6, 2012 at
Re: $$Excel-Macros$$ VBA : Class does not support automation error.
Dear Amol , Pl share a sheet with group. Thanks Regards, Gawli Anil On Fri, Nov 9, 2012 at 12:07 PM, Amol Jadhav asja...@gmail.com wrote: Hello Experts, I need your expert advice. I created a tool using VBA form and OWC 10.0. I am exporting chart which is on chartspace component(OWC 10.0). On some PC's tool is working fine, but on other computers I am getting an error Class does not support automation or does not support expected interface. I am using Windows 7 and office 2010 I am not able to upload file because its to heavy 19 mb. Please find attached error screenshot and highlighted line where i am getting this error. Please let know the possible reasons and solutions for the same. Regards, Amol J -- 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. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (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.
Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.
Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these characters from the table so that they can not be view in the from and table should be clean from such unwanted characters. I takes much time to remove them manually as my table contains more than 2000 records. Please help me by providing some suitable vba code or any other method. I need your help for this. Thanks in advance. -- With regards, *MaNgEsH* -- 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. -- Regards, Anoop -- 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. image.png
Re: $$Excel-Macros$$ multiple sheet reference..
Dear Mr. Ansari, thanks a lot for solution.. but i dont know that the particluar article place in which sheet. Means.. i cant select sheet from drop down list manually. Can you please advice how can i find that artilce from that 11 sheet by formula.? Thanks in advance. Regards Jafna kuwait. -- 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.
Re: $$Excel-Macros$$ multiple sheet reference..
Then you can use Global Vlookup Formula,provided by *Anil*. But it will very lengthy in case of 11 sheets. Syntax is here. in Excel 2007+ Version =iferror(*1st sheet vlookup*,iferror(*2ndsheet Vlookup*,iferror(*3rd Sheet Vlookup*,iferror(*4th Sheet Vlookup*...continue till 11 sheet in Excel 2003 =if(not(iserror(*ist vlookup*))),if(not(iserror(*2nd vlookup* ))...continue if you get any confusion,feel free to ask. On Fri, Nov 9, 2012 at 1:08 PM, satiqjaffar satiqjaffar satiqjaffar...@gmail.com wrote: Dear Mr. Ansari, thanks a lot for solution.. but i dont know that the particluar article place in which sheet. Means.. i cant select sheet from drop down list manually. Can you please advice how can i find that artilce from that 11 sheet by formula.? Thanks in advance. Regards Jafna kuwait. -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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.