Re: $$Excel-Macros$$ inquiry
Dear Anil, thank you very much Its wonder full man and were did you hide the picture Delin.F अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; delin_1...@yahoo.co.in Sent: Tuesday, 6 November 2012 10:50 AM Subject: Re: $$Excel-Macros$$ inquiry Pl find Attached Sheet herewith Regards, Gawli Anil On Tue, Nov 6, 2012 at 12:07 PM, DELIN FRANCIS delin_1...@yahoo.co.in wrote: Dear Members, is that possible in excel sheets if we input a name or some code of person in cell and i need his / her image to pop up in the specified space. here i attached file with some ex Delin.F -- 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. -- 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$$ inquiry
Dear Anil, if add more names then how can add more pics please tell me the way boss regards Delin.F From: DELIN FRANCIS delin_1...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 12:11 PM Subject: Re: $$Excel-Macros$$ inquiry Dear Anil, thank you very much Its wonder full man and were did you hide the picture Delin.F अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; delin_1...@yahoo.co.in Sent: Tuesday, 6 November 2012 10:50 AM Subject: Re: $$Excel-Macros$$ inquiry Pl find Attached Sheet herewith Regards, Gawli Anil On Tue, Nov 6, 2012 at 12:07 PM, DELIN FRANCIS delin_1...@yahoo.co.in wrote: Dear Members, is that possible in excel sheets if we input a name or some code of person in cell and i need his / her image to pop up in the specified space. here i attached file with some ex Delin.F -- 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. -- 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$$ inquiry
I found it... Me.Pictures.Visible = False change false to true... u can see all picture one by one.. Regard Manoj On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote: Dear Anil, if add more names then how can add more pics please tell me the way boss regards *Delin.F* -- *From:* DELIN FRANCIS delin_1...@yahoo.co.in *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Tuesday, 6 November 2012 12:11 PM *Subject:* Re: $$Excel-Macros$$ inquiry Dear Anil, thank you very much Its wonder full man and were did you hide the picture *Delin.F* अनिल नारायण गवली gawlianil8...@gmail.com *To:* excel-macros@googlegroups.com; delin_1...@yahoo.co.in *Sent:* Tuesday, 6 November 2012 10:50 AM *Subject:* Re: $$Excel-Macros$$ inquiry Pl find Attached Sheet herewith Regards, Gawli Anil On Tue, Nov 6, 2012 at 12:07 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote: Dear Members, is that possible in excel sheets if we input a name or some code of person in cell and i need his / her image to pop up in the specified space. here i attached file with some ex *Delin.F* -- 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. -- 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
Re: $$Excel-Macros$$ Calculate years and months between today daye and given date
Thanks for your help. Every solution is working and fine. Thanks once again friends -- 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$$ inquiry
see in selection pane On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote: Dear Anil, if add more names then how can add more pics please tell me the way boss regards *Delin.F* -- *From:* DELIN FRANCIS delin_1...@yahoo.co.in *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Tuesday, 6 November 2012 12:11 PM *Subject:* Re: $$Excel-Macros$$ inquiry Dear Anil, thank you very much Its wonder full man and were did you hide the picture *Delin.F* अनिल नारायण गवली gawlianil8...@gmail.com *To:* excel-macros@googlegroups.com; delin_1...@yahoo.co.in *Sent:* Tuesday, 6 November 2012 10:50 AM *Subject:* Re: $$Excel-Macros$$ inquiry Pl find Attached Sheet herewith Regards, Gawli Anil On Tue, Nov 6, 2012 at 12:07 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote: Dear Members, is that possible in excel sheets if we input a name or some code of person in cell and i need his / her image to pop up in the specified space. here i attached file with some ex *Delin.F* -- 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. -- 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
Fwd: $$Excel-Macros$$ Send mail from outlook Every One Hr .
*Dear Ashish* * * *There are 3 customers : a, b c.* * * Dist active passive total a 26 20 46 b 45 78 123 c 25 25 50 *It means all are having different e-mail id's, and the particular figures are to be sent only to specific customer only, then how we can send it in a single click.* * * *Please inform. Thanks,* * * *Regards* *Pravin Gunjal.** * -- Forwarded message -- From: ashish koul koul.ash...@gmail.com Date: Mon, Nov 5, 2012 at 10:43 PM Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . To: excel-macros@googlegroups.com check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.comwrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- 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* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs
Dear all, i am sending mail particular updated file summary sheet as body, every 1hr like 01:00hr,02:00hr,03:00hr plz any one send vba code for this work for outlook, -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- 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. Update data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Help Required on : Sending an Auto generated E-mail, If there is any Value in the Pivot
Dear Masters, Good evening... Could you kindly help me in sending an Auto generated e-mail Only when there is a value in the Pivot. Enclosed more info in the Excel sheet. Thanks in advance !!! JP -- 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. Help Required on - Sending an Auto Generated E-mail if there is any value exists in the Pivot.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com javascript: wrote: ** Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -- *From: * veerendra vanam veerend...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Mon, 5 Nov 2012 22:50:04 +0530 *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.comjavascript: wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.comjavascript: wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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. --
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- 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.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.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:15: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: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 javascript: 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 javascript: .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- 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.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.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 StringApplication.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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- 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)
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
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 StringApplication.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 StringApplication.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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- 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.
$$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
Hi Amar, I have attached a sheet. Please go thorugh. -- 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. Symbol.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
Hi Amar, Please find attached sheet. -- 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. Symbol.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12
Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Oct'12. He has posted 66 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. * Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- 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$$ Rajan Verma - Most Helpful Member October'12
Congrats!! On Tue, Nov 6, 2012 at 4:06 AM, Govind Mori mori.gov...@gmail.com wrote: Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Oct'12. He has posted 66 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. * Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- 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$$ Rajan Verma - Most Helpful Member October'12
Congrats Brother. -- 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 Tue, Nov 6, 2012 at 5:42 PM, Born to Win cs4...@gmail.com wrote: Congrats!! On Tue, Nov 6, 2012 at 4:06 AM, Govind Mori mori.gov...@gmail.com wrote: Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.comwrote: Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Oct'12. He has posted 66 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. * Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- 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
Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12
congratulation Rajan sir. On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori mori.gov...@gmail.com wrote: Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Oct'12. He has posted 66 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. * Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- 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$$ Send mail from outlook Every One Hr .
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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com wrote: Dear team i have data file in E drive i send mail to every 1 hr update mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365 days any macro from this type of works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
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 javascript: 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 javascript: .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 javascript: .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 Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub Where in you have to customise range A1 to give next delivery time. Rgds//Vabs On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Thanks for reply in this code when i am run the macro every 1 hr send automatically or we click the button every 1 hrplz tell me,, On Mon, Nov 5, 2012 at 10:43 PM, ashish koul koul@gmail.com wrote: check the
Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
I want also Neutral arrow On Tue, Nov 6, 2012 at 5:26 PM, Bali fmplrepo...@gmail.com wrote: Hi Amar, Please find attached sheet. -- 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$$ New Member
Hi * Ayush jainayus...@gmail.com,* * * *Please add the below mail id in the group.* * * mohd.sa...@in.aegisglobal.com* * * * *Regards,* *Surendra Singh* -- 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$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Sorry you feel that way. But from someone who has had many, many hours of effort expended only to have someone else take the coding and present it as his own, and not only get a PROMOTION because of the hours he saved, but had someone else terminated because they asked me for help... I tend to be more suspicious of people who try to get past the passwords to get access to someone else's code. and as for your assertion that you know the rules of the forum... if you do, then why did you INTENTIONALLY violate them? sorry if you took it the wrong way... *I* was trying in a friendly way (unsuccessfully, I guess) to explain WHY the rule exists. and I tried to humorously (poorly, I guess) to suggest that since WE aren't supposed to help break security, there are companies out there that DO. and really... take a look at your request from my perspective (and others): You sent out something that looks like class work (which, you said it is) and you're asking to break the security on it What would you do if one of your students sent this out for the same reason? - I guess I was feeling spunky yesterday, and should have done what I normally do and delete any emails that ignore rule #1: 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. sorry to have wasted your time and mine. But perhaps we've both learned something. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro almost from long time..appreciate your efforts in writing lengthy mail on this.. That exam itself designed by me..and I am not taking any exam ( Wrong prediction) ..think positively ...this will nt have any loss for any one Finally you suggested plenty of names for password...its better you use it urself and dont suggest to anyone, which is not necessary here..none of them buy ur suggestions here... Hope had clarified your doubts in your mind..finally the gud news is that I am capable of writing a VBA code to extract the source code in the file and I am able to open file and do modification in the current test.. Had posted this file in this forum to get speedy positive response.never thought ppl like dont know solution to issue and diverting the things in different way( negative minded persons--- I will really petty on your wife)...now your long philosophy is just waste of time of many.. Reagdrs,Bhanu On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net wrote: Notice Forum Rule #3? 3) Don't post questions regarding breaking or bypassing any security measure. WE don't have any way of knowing if you own the code or are simply trying break into the code to determine some type of proprietary information (hacking) If you are attempting to perform some illegal activity (obtain proprietary information, etc.) then we would them become accomplices in your activity. From the looks of your file, it looks like someone's classwork, in which you are attempting to find the correct answers, instead of doing the work... (if so, tsk tsk). If this is truly urgent, then there ARE companies out there (try Googling) that, for a fee, will attempt to circumvent the security of your file. These companies have their own procedures in place to protect them from the legal aspects of the service they provide. (hence the need for the fee) We, however, have no such protection. If, indeed, this is YOUR file, and need to get at the VBA in order to grade the exams, then I would suggest trying the name of your dog, wife, girlfriend, or combination thereof. (that is, the name of your girlfriend's dog, not girlfriend's wife.. which would be disturbing) sorry, and good luck. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, November 4, 2012 11:55:01 PM Subject: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Dear Team , Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me know how to do it..this is required
Re: $$Excel-Macros$$ Organization Chart
I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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,
Re: $$Excel-Macros$$ Organization Chart
I also Googled Excel vba Org Chart and received 189,000 hits. Perhaps someone else has already done this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum 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
RE: $$Excel-Macros$$ Organization Chart
Please have a look here http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-appli cations-smart-art.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 06 November 2012 7:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Organization Chart I also Googled Excel vba Org Chart and received 189,000 hits. Perhaps someone else has already done this? Paul - Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can. - John Wesley - _ From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can. - John Wesley - _ From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. _ From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post 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
Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Bhanu, Learn to spell. Paul, Right On! Paul Schreiner schreiner_p...@att.net wrote: Sorry you feel that way. But from someone who has had many, many hours of effort expended only to have someone else take the coding and present it as his own, and not only get a PROMOTION because of the hours he saved, but had someone else terminated because they asked me for help... I tend to be more suspicious of people who try to get past the passwords to get access to someone else's code. and as for your assertion that you know the rules of the forum... if you do, then why did you INTENTIONALLY violate them? sorry if you took it the wrong way... *I* was trying in a friendly way (unsuccessfully, I guess) to explain WHY the rule exists. and I tried to humorously (poorly, I guess) to suggest that since WE aren't supposed to help break security, there are companies out there that DO. and really... take a look at your request from my perspective (and others): You sent out something that looks like class work (which, you said it is) and you're asking to break the security on it What would you do if one of your students sent this out for the same reason? - I guess I was feeling spunky yesterday, and should have done what I normally do and delete any emails that ignore rule #1: 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. sorry to have wasted your time and mine. But perhaps we've both learned something. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro almost from long time..appreciate your efforts in writing lengthy mail on this.. That exam itself designed by me..and I am not taking any exam ( Wrong prediction) ..think positively ...this will nt have any loss for any one Finally you suggested plenty of names for password...its better you use it urself and dont suggest to anyone, which is not necessary here..none of them buy ur suggestions here... Hope had clarified your doubts in your mind..finally the gud news is that I am capable of writing a VBA code to extract the source code in the file and I am able to open file and do modification in the current test.. Had posted this file in this forum to get speedy positive response.never thought ppl like dont know solution to issue and diverting the things in different way( negative minded persons--- I will really petty on your wife)...now your long philosophy is just waste of time of many.. Reagdrs,Bhanu On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net wrote: Notice Forum Rule #3? 3) Don't post questions regarding breaking or bypassing any security measure. WE don't have any way of knowing if you own the code or are simply trying break into the code to determine some type of proprietary information (hacking) If you are attempting to perform some illegal activity (obtain proprietary information, etc.) then we would them become accomplices in your activity. From the looks of your file, it looks like someone's classwork, in which you are attempting to find the correct answers, instead of doing the work... (if so, tsk tsk). If this is truly urgent, then there ARE companies out there (try Googling) that, for a fee, will attempt to circumvent the security of your file. These companies have their own procedures in place to protect them from the legal aspects of the service they provide. (hence the need for the fee) We, however, have no such protection. If, indeed, this is YOUR file, and need to get at the VBA in order to grade the exams, then I would suggest trying the name of your dog, wife, girlfriend, or combination thereof. (that is, the name of your girlfriend's dog, not girlfriend's wife.. which would be disturbing) sorry, and good luck. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com
$$Excel-Macros$$
Dear Experts Can somebody please help me out. How to generate in the VBA selected contains shift to another column, find attached sample file Azeem -- 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. SAMPLE.xlsx Description: SAMPLE.xlsx
Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
use Webdings format 0 for netural 5 for up arrow 6 for down arrow Regards Ashish On Tue, Nov 6, 2012 at 6:08 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: You can use the Insert symbol dialog box, short key of Altr+I+S On Tue, Nov 6, 2012 at 5:31 PM, amar takale amartak...@gmail.com wrote: I want also Neutral arrow On Tue, Nov 6, 2012 at 5:26 PM, Bali fmplrepo...@gmail.com wrote: Hi Amar, Please find attached sheet. -- 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. -- Regards, Aamir Shahzad -- 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* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs
On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam veerendra.va...@gmail.comwrote: Dear all, i am sending mail particular updated file summary sheet as body, every 1hr like 01:00hr,02:00hr,03:00hr plz any one send vba code for this work for outlook, -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- 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. -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- 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$$ Follow forum rules and maintain discipline !!!
Group, Kindly request you all to follow rules that you see in signtures and I hope there will be no such heated arguments in future. You need not to respond to people who violate the forum rules, just forward me the email to ban the person. I will take decision to give warning or ban the person as appropriate. It is very important for us to maintain the discipline in the forum. Let me know if you have any queries or feedback. Thanks and warm regards Ayush Jain Group Manager On Tue, Nov 6, 2012 at 8:07 PM, bwo...@cox.net wrote: Bhanu, Learn to spell. Paul, Right On! Paul Schreiner schreiner_p...@att.net wrote: Sorry you feel that way. But from someone who has had many, many hours of effort expended only to have someone else take the coding and present it as his own, and not only get a PROMOTION because of the hours he saved, but had someone else terminated because they asked me for help... I tend to be more suspicious of people who try to get past the passwords to get access to someone else's code. and as for your assertion that you know the rules of the forum... if you do, then why did you INTENTIONALLY violate them? sorry if you took it the wrong way... *I* was trying in a friendly way (unsuccessfully, I guess) to explain WHY the rule exists. and I tried to humorously (poorly, I guess) to suggest that since WE aren't supposed to help break security, there are companies out there that DO. and really... take a look at your request from my perspective (and others): You sent out something that looks like class work (which, you said it is) and you're asking to break the security on it What would you do if one of your students sent this out for the same reason? - I guess I was feeling spunky yesterday, and should have done what I normally do and delete any emails that ignore rule #1: 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. sorry to have wasted your time and mine. But perhaps we've both learned something. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro almost from long time..appreciate your efforts in writing lengthy mail on this.. That exam itself designed by me..and I am not taking any exam ( Wrong prediction) ..think positively ...this will nt have any loss for any one Finally you suggested plenty of names for password...its better you use it urself and dont suggest to anyone, which is not necessary here..none of them buy ur suggestions here... Hope had clarified your doubts in your mind..finally the gud news is that I am capable of writing a VBA code to extract the source code in the file and I am able to open file and do modification in the current test.. Had posted this file in this forum to get speedy positive response.never thought ppl like dont know solution to issue and diverting the things in different way( negative minded persons--- I will really petty on your wife)...now your long philosophy is just waste of time of many.. Reagdrs,Bhanu On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net wrote: Notice Forum Rule #3? 3) Don't post questions regarding breaking or bypassing any security measure. WE don't have any way of knowing if you own the code or are simply trying break into the code to determine some type of proprietary information (hacking) If you are attempting to perform some illegal activity (obtain proprietary information, etc.) then we would them become accomplices in your activity. From the looks of your file, it looks like someone's classwork, in which you are attempting to find the correct answers, instead of doing the work... (if so, tsk tsk). If this is truly urgent, then there ARE companies out there (try Googling) that, for a fee, will attempt to circumvent the security of your file. These companies have their own procedures in place to protect them from the legal aspects of the service they provide. (hence the need for the fee) We, however, have no such protection. If, indeed, this is YOUR file, and need to get at the VBA in order to grade the exams, then I would suggest trying
$$Excel-Macros$$ Re: QC results update tool
Hi Friends, Did you guys find time to look into my Question.I tried a lot but was unsucessfull today. Below code is what we used for connecting quality center with no sucess.This code might work for QUality center 10. But in HP ALM(Quality center 11) methodologoy is slightly different after entering user name,password we need to click on the authenticate button then we need to select domain,Project and then click on the Login button. It failes wehn we used the connect method (QCcon.Connect Domain, Project).Iam suspecting it has to do something with the authentication button Please suggest me. Sub CreateConnection() Dim qcUser As String Dim qcPassword As String Dim qcDomain As String Dim qcProject As String Dim qcHostName As String qcUser = Username qcPassword = Password qcDomain = DomainName qcProject = ProjectName Set QCcon = CreateObject(TDApiOle80.TDConnection) QCcon.InitConnectionEx HP ALM url QCcon.Login UserName, Password QCcon.Connect Domain, Project MsgBox connection established End Sub On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: Hi Friends, Iam not able to find the right kind of code which is used to connect QC test lab folder using macros.Objective is to update around 1200 tc using macros. It would be great if somebody is guiding me and iam very new to using macros.. Regards -- 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$$ Solver in excel
do you have a sample worksheet that shows how to use a solver for optimization problems. On Tue, Apr 10, 2012 at 7:51 AM, Rajan_Verma rajanverma1...@gmail.comwrote: As I study the solver, I feel this is elder brother of Goal Seek in Excel ,where we can change only one value with Goal seek , Using Solver we can provide many cell for adjusting value as per our scenario , Below is the Parameter required to solver , We can add many scenario to see different analysis, ** ** Using Spreadsheets. Spreadsheets such as Microsoft Excel provide a convenient way to build such a model. Cells on a worksheet can hold numbers, labels, or formulas that calculate new values. - The decision variables for a model are simply worksheet cells containing numbers that Solver can change. - The objective is a cell containing a formula you want Solver to maximize (or minimize) by adjusting the values of the decision variable cells. - Constraints are logical conditions on formula cells that must be satisfied (specified with =, = or = relations). Frontline's various Solver products provide powerful tools for solving, or optimizing, such models. ** ** ** ** Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan *Sent:* Apr/Tue/2012 04:45 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solver in excel ** ** *Hi Expert, Can somebody please guide me what is the use of solver in excel by the help of example ?? with different different criteria !!!.. Thanks in advance. * Thanks Regards, *Deba Ranjan P* ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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$$ Excel dashboards
Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- 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$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
bworth - Watt need to learn to spell.. On Tue, Nov 6, 2012 at 8:07 PM, bwo...@cox.net wrote: Bhanu, Learn to spell. Paul, Right On! Paul Schreiner schreiner_p...@att.net wrote: Sorry you feel that way. But from someone who has had many, many hours of effort expended only to have someone else take the coding and present it as his own, and not only get a PROMOTION because of the hours he saved, but had someone else terminated because they asked me for help... I tend to be more suspicious of people who try to get past the passwords to get access to someone else's code. and as for your assertion that you know the rules of the forum... if you do, then why did you INTENTIONALLY violate them? sorry if you took it the wrong way... *I* was trying in a friendly way (unsuccessfully, I guess) to explain WHY the rule exists. and I tried to humorously (poorly, I guess) to suggest that since WE aren't supposed to help break security, there are companies out there that DO. and really... take a look at your request from my perspective (and others): You sent out something that looks like class work (which, you said it is) and you're asking to break the security on it What would you do if one of your students sent this out for the same reason? - I guess I was feeling spunky yesterday, and should have done what I normally do and delete any emails that ignore rule #1: 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. sorry to have wasted your time and mine. But perhaps we've both learned something. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: bhanu prakash bhanu...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 6:18:11 AM Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required** Paul, I know the Rules of the forum...I had using this forum fro almost from long time..appreciate your efforts in writing lengthy mail on this.. That exam itself designed by me..and I am not taking any exam ( Wrong prediction) ..think positively ...this will nt have any loss for any one Finally you suggested plenty of names for password...its better you use it urself and dont suggest to anyone, which is not necessary here..none of them buy ur suggestions here... Hope had clarified your doubts in your mind..finally the gud news is that I am capable of writing a VBA code to extract the source code in the file and I am able to open file and do modification in the current test.. Had posted this file in this forum to get speedy positive response.never thought ppl like dont know solution to issue and diverting the things in different way( negative minded persons--- I will really petty on your wife)...now your long philosophy is just waste of time of many.. Reagdrs,Bhanu On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net wrote: Notice Forum Rule #3? 3) Don't post questions regarding breaking or bypassing any security measure. WE don't have any way of knowing if you own the code or are simply trying break into the code to determine some type of proprietary information (hacking) If you are attempting to perform some illegal activity (obtain proprietary information, etc.) then we would them become accomplices in your activity. From the looks of your file, it looks like someone's classwork, in which you are attempting to find the correct answers, instead of doing the work... (if so, tsk tsk). If this is truly urgent, then there ARE companies out there (try Googling) that, for a fee, will attempt to circumvent the security of your file. These companies have their own procedures in place to protect them from the legal aspects of the service they provide. (hence the need for the fee) We, however, have no such protection. If, indeed, this is YOUR file, and need to get at the VBA in order to grade the exams, then I would suggest trying the name of your dog, wife, girlfriend, or combination thereof. (that is, the name of your girlfriend's dog, not girlfriend's wife.. which would be disturbing) sorry, and good luck. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you
Re: $$Excel-Macros$$ Excel dashboards
You can also visit *chandoo*.*org*/wp/excel-*dashboards*/ www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard * On Wed, Nov 7, 2012 at 9:52 AM, son nguyen sonnguye...@gmail.com wrote: Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- 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.
Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
Dear Amar, See attached sheet,hope it will help you to resolve your array problem On Wed, Nov 7, 2012 at 9:50 AM, amar takale amartak...@gmail.com wrote: Dear ashish, Thanks for guide me,but I want arrow like in sheet Pls see sheet. On Tue, Nov 6, 2012 at 9:15 PM, ashish koul koul.ash...@gmail.com wrote: use Webdings format 0 for netural 5 for up arrow 6 for down arrow Regards Ashish On Tue, Nov 6, 2012 at 6:08 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: You can use the Insert symbol dialog box, short key of Altr+I+S On Tue, Nov 6, 2012 at 5:31 PM, amar takale amartak...@gmail.comwrote: I want also Neutral arrow On Tue, Nov 6, 2012 at 5:26 PM, Bali fmplrepo...@gmail.com wrote: Hi Amar, Please find attached sheet. -- 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. -- Regards, Aamir Shahzad -- 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* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- 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. Data1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel dashboards
Thank Mr NOORAIN very much. Regards Son 2012/11/7 NOORAIN ANSARI noorain.ans...@gmail.com You can also visit *chandoo*.*org*/wp/excel-*dashboards*/ www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard * On Wed, Nov 7, 2012 at 9:52 AM, son nguyen sonnguye...@gmail.com wrote: Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- 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. -- Best Regards Son -- 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$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Dear Sanusi, Pls use below formula =LEFT(B3,FIND(),B3,1)) =RIGHT(B3,LEN(B3)-FIND(),B3)) see attachment for more clarity. Please use separate thread for your fresh query instead of another thread. -- 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 Wed, Nov 7, 2012 at 11:10 AM, Mohd Sanusi Mohd Noor sanus...@gmail.comwrote: Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- 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. Copy of Data1(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel dashboards
Thanks Noorain for sharing good stuffs on creating dashboards. Regards Prince On Wednesday, November 7, 2012 11:05:03 AM UTC+5:30, NOORAIN ANSARI wrote: You can also visit *chandoo*.*org*/wp/excel-*dashboards*/ www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard * On Wed, Nov 7, 2012 at 9:52 AM, son nguyen sonng...@gmail.comjavascript: wrote: Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- 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-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$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Hi Sanusi, Please Paste the followint formulas. In D1 =LEFT(B3,2) In E1 =MID(B3,3,LEN(B3)-2) and drag up to thwe number of rows as data in B columns. Regards Prince On Wednesday, November 7, 2012 11:10:45 AM UTC+5:30, msn wrote: Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- 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$$ Organization Chart
Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node. Can you please recheck ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:10 PM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: noorain.ans...@gmail.com noorain.ans...@gmail.com; excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+
Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel
Hi Great Noorain Bhai,Thanks very much.It is very helpful to me arrow also other symbol to use in excel Thanks again Regards Amar On Wed, Nov 7, 2012 at 11:06 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, See attached sheet,hope it will help you to resolve your array problem On Wed, Nov 7, 2012 at 9:50 AM, amar takale amartak...@gmail.com wrote: Dear ashish, Thanks for guide me,but I want arrow like in sheet Pls see sheet. On Tue, Nov 6, 2012 at 9:15 PM, ashish koul koul.ash...@gmail.comwrote: use Webdings format 0 for netural 5 for up arrow 6 for down arrow Regards Ashish On Tue, Nov 6, 2012 at 6:08 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: You can use the Insert symbol dialog box, short key of Altr+I+S On Tue, Nov 6, 2012 at 5:31 PM, amar takale amartak...@gmail.comwrote: I want also Neutral arrow On Tue, Nov 6, 2012 at 5:26 PM, Bali fmplrepo...@gmail.com wrote: Hi Amar, Please find attached sheet. -- 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. -- Regards, Aamir Shahzad -- 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* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES
Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**
Dear Noorain Prince, Thank you very much for the formula solutions. Best regards Sanusi On 7 November 2012 13:51, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sanusi, Pls use below formula =LEFT(B3,FIND(),B3,1)) =RIGHT(B3,LEN(B3)-FIND(),B3)) see attachment for more clarity. Please use separate thread for your fresh query instead of another thread. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/ On Wed, Nov 7, 2012 at 11:10 AM, Mohd Sanusi Mohd Noor sanus...@gmail.com wrote: Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- 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.
FW: $$Excel-Macros$$
Dear NOORAIN ANSARI I am having huge data like attached file DATA sheet, from description column selected contains need to copy sheet2 with vba code which is very helpful for me, please see attached file sheet Data and sheet2 for your understand. Thanks in advance Azeem Quraishi From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, November 07, 2012 10:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dear Azeem, Please explain more, what is your exact need. On Tue, Nov 6, 2012 at 9:08 PM, Sayed Abdul Azeem (QFD) sabdulaz...@ccc.ae wrote: Dear Experts Can somebody please help me out. How to generate in the VBA selected contains shift to another column, find attached sample file -- 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:// http://www.noorainansari.com noorainansari.com http://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com 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. SAMPLE.xlsx Description: SAMPLE.xlsx