$$Excel-Macros$$ Fwd: Doubt
Hi, How to insert specific column values from excel to sql table using visubal basic dot net. Thanks, Sharma -- 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.
$$Excel-Macros$$ Doubt
Hi team, Need example for how to insert specific column values from excel to sql table. using vb.net Thanks, Sharma -- 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.
$$Excel-Macros$$ Unprotect - VBA Password
Hi Team, I have created a tool in vba with password protected. I have forgot the password. Now I want to do some changes in the tool based on the requirement. so please remove the vba password and send me the tool as soon as possible. Also it would be great if any one help me to create add ins. Regards, Sharma -- 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 Cab Delay - 1.0.0.xlsm Description: Binary data
Re: $$Excel-Macros$$ SQL Query - Excel VBA
Hi, Please see my comments in the tag [sharma]. Regards, Sharma On Sat, Mar 24, 2012 at 1:40 AM, Asa Rossoff a...@lovetour.info wrote: Hi Sharma, I replied two weeks ago when you posted this question with a detailed response with tips and requesting more information if you still needed help. ** ** You didn't reply, but here is my post again. I can help more, bnut please review what I already said and let me know what help you still need. -- Hi Sharma, How do you define failure for the first query? 0 records returned? an error from the database server/engine? ** [Sharma] Yes you are correct. If 0 records found then we need to run the second query and so on. What do you want to do with the result of the query? Put it on a (new?) sheet in your workbook? [Sharma] Yes I want the result should be updated in a new sheet. **writing** the queries using VBA is very simple. The following assembles the first query statement in a string variable: Sub WriteSQLquery () Dim SQL As String SQL = _ SELECT _ distinct AMRCostCtr _ FROM _ [SRT1].[RequestToolDev].[dbo].[vReqsocs] a, _ [SRT1].[RequestToolDev].[dbo].[ReqMain] b _ WHERE _ a.ReqID = b.ReqID and MainRequestNumber = '365700'; End Sub ** ** Here's a robust-looking, general-purpose procedure called *SQLLoad* to open a recordset for your query and copy the data to a worksheet: Beyond Excel - Say Goodbye to QueryTableshttp://itknowledgeexchange.techtarget.com/beyond-excel/say-goodbye-to-querytables/. The associated blog actually contains a lot of good information and code for working with databases from Excel (some of it advanced). ** ** You will need a connection string to identify your data source and (if needed) credentials. Connectionstrings.comhttp://www.connectionstrings.com/has a large index of connection string examples. You should avoid Microsoft Jet connection strings and in cases where there are alternatives, ODBC connection strings, which have been replaced by newer drivers. (ODBC is still fine and commonly used with many non-Microsoft data stores). ** ** See if the above info gets you started. I can provide more help if needed. Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amrahs k *Sent:* Friday, March 23, 2012 6:22 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ SQL Query - Excel VBA ** ** Hi Team, Here I am posting a request for running sql queries in excel macro. I have listed my queries below. Currently am running these queries manually. I want these queries needs to be run automatically. SELECT distinct AMRCostCtr FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs] a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b where a.ReqID = b.ReqID and MainRequestNumber = '353817' If the above query does not return a result then it should automatically run the second query and then second query as shown below. SELECT StationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMROOS WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) if the above one fails then it should run for the third one which is given below. SELECT BillableStationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMRIMAC WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) Please help me to get this done. Thanks, Sharma Krishnan -- 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
$$Excel-Macros$$ SQL Query - Excel VBA
Hi Team, Here I am posting a request for running sql queries in excel macro. I have listed my queries below. Currently am running these queries manually. I want these queries needs to be run automatically. SELECT distinct AMRCostCtr FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs] a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b where a.ReqID = b.ReqID and MainRequestNumber = '353817' If the above query does not return a result then it should automatically run the second query and then second query as shown below. SELECT StationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMROOS WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) if the above one fails then it should run for the third one which is given below. SELECT BillableStationBranch FROM [SRT1].RequestToolDev.dbo.ReqAMRIMAC WHERE ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain where mainrequestnumber = 353817) Please help me to get this done. Thanks, Sharma Krishnan -- 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
$$Excel-Macros$$ Connect Access Database
Dear Team, Can any one please suggest me that how to connect MS - Access database using Visual Basic. I have a database mdb file and I want to connect it from VB front end. Any help or suggestion will be greatly appreciated. Thanks, Sharma -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ Re: Need Small Help to pull values based on the criteira!
Hi Bhushan, This helps lot and solves my query as well. Thanks for your time and the help. Regards, Sharma On Tue, Apr 12, 2011 at 12:14 PM, Bhushan Sabbani bsabban...@gmail.comwrote: Dear Sharma, Pls find the attachment. pls let me know if there is any problem or the solution was helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Small Help to pull values based on the criteira!
Hi Anil, Thanks for your help. This works great. Regards, Sharma On Mon, Apr 11, 2011 at 5:57 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Amrahas, Please check this. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amrahs k *Sent:* Monday, April 11, 2011 3:32 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need Small Help to pull values based on the criteira! Hi Team, I have attached the sample spreadsheet with my query. Kindly help me to solve the same. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need Small Help to pull values based on the criteira!
Hi Team, I have attached the sample spreadsheet with my query. Kindly help me to solve the same. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Sample 1.1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Need Excel Formula or VBA Function to Solve the Query.
Brilliant! Thanks for your support Ayush. Best Regards, Sharma On Sun, Dec 12, 2010 at 1:35 PM, Ayush jainayus...@gmail.com wrote: Dear Sharma, Attached is the solution. I have used COUNTIFS formula to get this done. I hope it helps. Please let us know if any further assistance is required. Thanks. Best Regards, Ayush Jain Microsoft MVP 2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Fwd: Need Change!
Hi, Thanks for the swift response. I came up with different scenario after applying the new function that you shared me. Input: DECLARATION BY LAW ENFORCEMENT FOR WALK-THROUGH ARREST WARRANT AND ORDER Output: Declaration by Law Enforcement for Walk-through Arrest Warrant and Order Input: SETTLEMENT CONFERENCE BRIEF/MANDATORY TRIAL STATEMENT Output: Settlement Conference Brief/mandatory Trial Statement Input: “DECLARATION” FOR “COURT” ASSIGNMENT Output: “declaration” for “court” Assignment It also does not handle the following special characters */ -* Kindly look into this and help me to overcome this issue. Thanks, Sharma On Sat, Nov 13, 2010 at 8:49 PM, roberto mensa robb@gmail.com wrote: try this function changed Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?(]\b|[.!?(]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function regards r 2010/11/13 amrahs k amrahs...@gmail.com Hi, First I would like to say thank to you. The script that you had given to me works fine though I have a constraint as- The below code is does not handle ( in the input. Please look into the below example. *Input: CASE MANAGEMENT CONFERENCE QUESTIONNAIRE (LOCAL RULE 12.7)* *Output: Case Management Conference Questionnaire (local Rule 12.7)* It does not handle the open paranthesis (. As a result the word LOCAL has been converted in local. Kindly look into this and help me to solve this. Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR MsgBox ProperCase_r(s) End Sub *Thanks,* *Sharma* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips
Fwd: $$Excel-Macros$$ Fwd: Need Change!
Hi, Any update on the below email? I am awaiting for your response. It would be great if you could share this by today. Thanks, Sharma -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Mon, Nov 15, 2010 at 2:54 PM Subject: Re: $$Excel-Macros$$ Fwd: Need Change! To: excel-macros@googlegroups.com Hi, Thanks for the swift response. I came up with different scenario after applying the new function that you shared me. Input: DECLARATION BY LAW ENFORCEMENT FOR WALK-THROUGH ARREST WARRANT AND ORDER Output: Declaration by Law Enforcement for Walk-through Arrest Warrant and Order Input: SETTLEMENT CONFERENCE BRIEF/MANDATORY TRIAL STATEMENT Output: Settlement Conference Brief/mandatory Trial Statement Input: “DECLARATION” FOR “COURT” ASSIGNMENT Output: “declaration” for “court” Assignment It also does not handle the following special characters */ -* Kindly look into this and help me to overcome this issue. Thanks, Sharma On Sat, Nov 13, 2010 at 8:49 PM, roberto mensa robb@gmail.com wrote: try this function changed Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?(]\b|[.!?(]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function regards r 2010/11/13 amrahs k amrahs...@gmail.com Hi, First I would like to say thank to you. The script that you had given to me works fine though I have a constraint as- The below code is does not handle ( in the input. Please look into the below example. *Input: CASE MANAGEMENT CONFERENCE QUESTIONNAIRE (LOCAL RULE 12.7)* *Output: Case Management Conference Questionnaire (local Rule 12.7)* It does not handle the open paranthesis (. As a result the word LOCAL has been converted in local. Kindly look into this and help me to solve this. Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR MsgBox ProperCase_r(s) End Sub *Thanks,* *Sharma* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Required to Unprotect VBA password
Hi, Thanks for your help. Regards, -Sharma On Fri, Nov 12, 2010 at 1:45 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear See Regards Sumit On Fri, Nov 12, 2010 at 1:11 PM, amrahs k amrahs...@gmail.com wrote: Hi, Kindly unprotect the attached workbook vba password. Since it is very urgent. Thanks a ton, -Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Help Required!
Hi, I have attached a spreadsheet which contains list of document numbers and their respective names. What I want is I need a word macro that will do the following. Note: The file name will always starts with the Doc Number (5 digits). Ex: 12345 (Refer Sample_Findlaw.xls for list of Doc Number) User will enter the Name of the corresponding Doc Number in the word document. I need a macro that would populate a message box like Mismatch between Name and Doc Number when they enter wrong name in the word document. Example: Consider File Name is 97854Test1.doc (Refer the spreadsheet Sample_Findlaw.xls) Name for this Doc Number is : New York If the user enter Texas instead of New York then the macro would populate a message box. Please help me to fix this. Thanks, Sharma On Mon, Nov 1, 2010 at 10:41 AM, amrahs k amrahs...@gmail.com wrote: Hi, This is what I actually looking for. It works great and solves my query. Thanks for your efforts and help. Regards, Sharma On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa robb@gmail.comwrote: the sub test is just one example of how to use the function into a routine. Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR s = ProperCase_r(s) Debug.Print s End Sub r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts 97854Test1.doc Description: MS-Word document Sample_Findlaw.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Help Required!
Hi, This is what I actually looking for. It works great and solves my query. Thanks for your efforts and help. Regards, Sharma On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa robb@gmail.com wrote: the sub test is just one example of how to use the function into a routine. Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR s = ProperCase_r(s) Debug.Print s End Sub r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Help Required!
Hi, I meant to say every time I need to change the S value as Input which is taking more time. I am unable to copy the result since it is showed via message box. I want to copy the result and updated in documents. It would be helpful if you could change the code as per the need.(Macro have to replace the input with the output instead of populating through message box.) Thanks, Sharma On Thu, Oct 28, 2010 at 3:41 PM, roberto mensa robb@gmail.com wrote: I don't understand which linguage do you use? In visual basic as I have proposed is a function you can pass any text and use its result regards r 2010/10/28 amrahs k amrahs...@gmail.com Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The code gives the output through message box. Due to this I am unable to copy the value (i.e) Output. Also the code is only execute for the input AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR. What I need to have is to applicable for any kind of inputs (i.e) the input value is not constant it may change as per the user requirement. Please help me to overcome this and many thanks in advance. Regards, Sharma On Wed, Oct 27, 2010 at 9:49 PM, r robb@gmail.com wrote: try this function: Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR MsgBox ProperCase_r(s) End Sub regards r On 27 Ott, 11:25, amrahs k amrahs...@gmail.com wrote: Hi Team, I want a macro in MS word that will do the following. It will first convert the upper case into title case and then replace every connecting word with lower case. *Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR *Required Output:* Agreement. The Adoption the Adult or Married Minor *Note:* The connecting word “THE” has been replaced by “the” however the macro left the first connecting word “THE” that followed by dot (.) Your help would be greatly appreciated. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Help Required!
Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The code gives the output through message box. Due to this I am unable to copy the value (i.e) Output. Also the code is only execute for the input AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR. What I need to have is to applicable for any kind of inputs (i.e) the input value is not constant it may change as per the user requirement. Please help me to overcome this and many thanks in advance. Regards, Sharma On Wed, Oct 27, 2010 at 9:49 PM, r robb@gmail.com wrote: try this function: Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯ Dim v, i As Long, x Dim re As Object Set re = CreateObject(vbscript.regexp) re.Global = True s = VBA.StrConv(s, vbProperCase) v = Split(an|a|the|or|and|on|over|abore| _ under|blow|between|near|beside|among, |) For Each x In v re.Pattern = \b VBA.StrConv(x, vbProperCase) \b s = re.Replace(s, x) Next Debug.Print s re.Pattern = _ (^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.) ProperCase_r = _ re.Replace(s, $1§$2§) v = Split(ProperCase_r, _ §, , vbTextCompare) For i = 1 To UBound(v) Step 2 v(i) = VBA.StrConv(v(i), vbUpperCase) Next ProperCase_r = Join(v, ) End Function Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR MsgBox ProperCase_r(s) End Sub regards r On 27 Ott, 11:25, amrahs k amrahs...@gmail.com wrote: Hi Team, I want a macro in MS word that will do the following. It will first convert the upper case into title case and then replace every connecting word with lower case. *Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR *Required Output:* Agreement. The Adoption the Adult or Married Minor *Note:* The connecting word “THE” has been replaced by “the” however the macro left the first connecting word “THE” that followed by dot (.) Your help would be greatly appreciated. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Help Required!
Hi Team, I want a macro in MS word that will do the following. It will first convert the upper case into title case and then replace every connecting word with lower case. *Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR *Required Output:* Agreement. The Adoption the Adult or Married Minor *Note:* The connecting word “THE” has been replaced by “the” however the macro left the first connecting word “THE” that followed by dot (.) Your help would be greatly appreciated. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Need Suggestion!
Dear Experts, I need quick suggestion to solve the below issue. Issue: Team use to update a spreadsheet for tracking their hours details for extending the shift. After a day the values in the spreadsheet gets changed this is because people might miss use it. So I want a backup spreadsheet of this to trace the changes. Whatever they are updating or changing in the spreadsheet1 will need to reflect in spreadsheet2 for my reference. Can this be done through VBA? Please share your thoughts to make life simple. Many thanks in Advance, -Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ VBA project password: Unprotect
Hi, Can anyone please assist me on this. Thanks, Sharma On Wed, Sep 29, 2010 at 10:08 AM, amrahs k amrahs...@gmail.com wrote: Hi Team, I have attached the spreadsheet in which VBA project was protected with password. Due to this I am unable to edit the code as well. Kindly advice me to solve this issue. Please let me know whether any method to crack the VBA project password so that I can apply the same in near future. Refer the attachment. Do the needful. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Help Needed!
Hi Vasant, I am trying to create a macro to do this below task to avoid manual efforts. For more details please refer the below email. Here is my code- Sub Movefiles() Dim a As Integer Dim fso, f2 With Application.FileSearch .LookIn = C:\LLF\ Range(A1).Value .FileType = msoFileTypeAllFiles .Execute MsgBox Total Files Available is : (.FoundFiles.Count) a = WorksheetFunction.Sum((.FoundFiles.Count) / 50) If .FoundFiles.Count 50 Then On Error GoTo 1 MkDir C:\Amrahs ' change the path and name MsgBox (Folder Created) Exit Sub 1 MsgBox (Folder Already Exist!) Else If .FoundFiles.Count 50 Then Do While a 0 MkDir C:\Target\Amrahs a MsgBox (Folder Created) Loop End If End If End With End Sub Am getting error message in the highlighted line. Also this code is only use to create folders based on number of files available in the specified folder. If the folder contains 500 files then it should be divided by a constant number 50 and you will get 10. So 10 folders needs to be created. Additonally while creating folders the code should move 50 files to the first folder and the next 50 files to the second folder and so on. At last all the 500 files should be moved to the respective 10 folders. If the file count is 480 or 500 then the remaining files should be moved to the last folder. Please look into this and help me to overcome this issue since it is very much required as every time am doing it manually. Any idea or suggestion will be greatly appreciated. Thanks a lot! -Sharma On Mon, Aug 30, 2010 at 12:36 PM, amrahs k amrahs...@gmail.com wrote: Dear Experts, I have a problem to work on a folder where in I need to do manually to do the below task. I have a folder named as Calibration in C: drive. It contains 500 excel files. What I want to do is to create new folder1 and move 50 files to it. Then another 50 files to new folder2 till the folder gets empty (i.e) all the files moved to new folder. Can we do it using VBA. Please suggest me to solve this issue. Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help Needed!
Dear Experts, I have a problem to work on a folder where in I need to do manually to do the below task. I have a folder named as Calibration in C: drive. It contains 500 excel files. What I want to do is to create new folder1 and move 50 files to it. Then another 50 files to new folder2 till the folder gets empty (i.e) all the files moved to new folder. Can we do it using VBA. Please suggest me to solve this issue. Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help Needed!
Hi, Am not familiar with access and it would be great if I get macro or vba script to do the below task. Or please explain me in detail. Thanks in Advance, Sharma On Mon, Aug 30, 2010 at 2:32 PM, adel elshafe adel.elsh...@og.com.egwrote: *Dear Sharma I have small idea but its may be help you use in access refrence Microsoft scripting runtime it makes you copy files , create folders any things related files if you fail send i have already form access* On Mon, Aug 30, 2010 at 10:06 AM, amrahs k amrahs...@gmail.com wrote: Dear Experts, I have a problem to work on a folder where in I need to do manually to do the below task. I have a folder named as Calibration in C: drive. It contains 500 excel files. What I want to do is to create new folder1 and move 50 files to it. Then another 50 files to new folder2 till the folder gets empty (i.e) all the files moved to new folder. Can we do it using VBA. Please suggest me to solve this issue. Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- *Thank you and best regards,* *Adel Elshafe'y* *HRIS Delta Electrical Appliances - IDEAL Olympic Group* *Address : 10th of Ramadan City, 3rd Industrial Zone, # 132 and 133 Mobile : 012 4331505 Tel. : 015 - 411531 / 390290 ext. 012 Fax : 015 - 390200 * Email : adel.elsh...@gmail.com.eg Web : www.OlympicGroup.com http://www.olympicgroup.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help Required!
Hi Ashish, Am still getting compile error since i am using microsoft outlook 2000 version. Can this code work in 2000 version or I should execute this code using 2007 version. Please advice me. Thanks, Sharma On Fri, Aug 27, 2010 at 1:51 PM, ashish koul koul.ash...@gmail.com wrote: On Fri, Aug 27, 2010 at 1:37 PM, ashish koul koul.ash...@gmail.comwrote: in reference select Microsoft outlook Regards Ashish koul akoul.blogspot.com On Fri, Aug 27, 2010 at 10:06 AM, amrahs k amrahs...@gmail.com wrote: Hi Koul, Thanks a lot for your effort and time. I have a response for the below code. I get compile error: Can't find project or library while running macro. line error: Dim olApp As Outlook.Application Please look into this and advice me how to proceed with this. Regards, Sharma On Thu, Aug 26, 2010 at 9:18 PM, ashish koul koul.ash...@gmail.comwrote: Sub maildata() Dim a As Workbook Dim data As Range Set data = ThisWorkbook.Sheets(1).Range(a1:f27) data.Copy Set a = Workbooks.Add a.Sheets(1).Cells(1, 1).Select ActiveSheet.Paste MsgBox ThisWorkbook.Path a.SaveAs ThisWorkbook.Path \abc1.xls a.Close Dim olApp As Outlook.Application Dim olMail As MailItem Dim SigString As String Dim Signature As String Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = koul.ash...@gmail.com .CC = a...@rediffmail.com .Subject = Incoming Status! .Body = Messages vbCrLf vbCrLf Thanks vbCrLf Regards vbCrLf Ashish Koul .Attachments.Add ThisWorkbook.Path \abc1.xls .Send End With Set olMail = Nothing 'Kill ThisWorkbook.Path \abc1.xls End Sub Regards Ashish Koul akoul.blogspot.com On Wed, Aug 25, 2010 at 8:48 AM, amrahs k amrahs...@gmail.com wrote: Hi Team Members, I have a query with regard to outlook email. Can anyone please suggest or advice me how to proceed with this. Requirement: An email should be send automatically with below subject and body to the mentioned address. Copying the left most sheet in the attached excel in a separate workbook.(Please refer attached excel sheet) Details: To:= amrahs...@gmail.com CC:= amra...@gmail.com Subject:= Incoming Status! Body:= Tracker have been updated and Job card is generated for the same. Please check the attachment for more details. Thanks in Advance, Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks
Re: $$Excel-Macros$$ Help Required!
Hi Koul, Thanks a lot for your effort and time. I have a response for the below code. I get compile error: Can't find project or library while running macro. line error: Dim olApp As Outlook.Application Please look into this and advice me how to proceed with this. Regards, Sharma On Thu, Aug 26, 2010 at 9:18 PM, ashish koul koul.ash...@gmail.com wrote: Sub maildata() Dim a As Workbook Dim data As Range Set data = ThisWorkbook.Sheets(1).Range(a1:f27) data.Copy Set a = Workbooks.Add a.Sheets(1).Cells(1, 1).Select ActiveSheet.Paste MsgBox ThisWorkbook.Path a.SaveAs ThisWorkbook.Path \abc1.xls a.Close Dim olApp As Outlook.Application Dim olMail As MailItem Dim SigString As String Dim Signature As String Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = koul.ash...@gmail.com .CC = a...@rediffmail.com .Subject = Incoming Status! .Body = Messages vbCrLf vbCrLf Thanks vbCrLf Regards vbCrLf Ashish Koul .Attachments.Add ThisWorkbook.Path \abc1.xls .Send End With Set olMail = Nothing 'Kill ThisWorkbook.Path \abc1.xls End Sub Regards Ashish Koul akoul.blogspot.com On Wed, Aug 25, 2010 at 8:48 AM, amrahs k amrahs...@gmail.com wrote: Hi Team Members, I have a query with regard to outlook email. Can anyone please suggest or advice me how to proceed with this. Requirement: An email should be send automatically with below subject and body to the mentioned address. Copying the left most sheet in the attached excel in a separate workbook.(Please refer attached excel sheet) Details: To:= amrahs...@gmail.com CC:= amra...@gmail.com Subject:= Incoming Status! Body:= Tracker have been updated and Job card is generated for the same. Please check the attachment for more details. Thanks in Advance, Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help Required!
Hi Team Members, I have a query with regard to outlook email. Can anyone please suggest or advice me how to proceed with this. Requirement: An email should be send automatically with below subject and body to the mentioned address. Copying the left most sheet in the attached excel in a separate workbook.(Please refer attached excel sheet) Details: To:= amrahs...@gmail.com CC:= amra...@gmail.com Subject:= Incoming Status! Body:= Tracker have been updated and Job card is generated for the same. Please check the attachment for more details. Thanks in Advance, Regards, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Fwd: Help Needed_Very Urgent
Hi Vasant, I have sent an email to you with regard to the date ranges. Please refer that mail and do the needful. Thanks a lot for your help. Regards, Sharma On Thu, Jul 29, 2010 at 10:31 PM, Vasant vasant...@gmail.com wrote: Hi, The Recd Date and Completion date is differs for each employee. So you mean to say that date range has to be generated for each employee. Could you suggest the format in which you want this to be done ? Regard Vasant Hi Vasant, This works great. Thanks for your help. Need a small change on this. The attached file will have dates already presented in sheet Dummy. Now what I want to have the dates automatically populated when macro running. The macro should check the minimum date in column E(Recv Date) and maximum date in column F(Compleation Date). Then it should populate the dates from min date to max date automatically. As and when I run the macro it should populate the dates based on minimum and maximum automatically. Note: if min date is 09/07/2010 and max date is 12/08/2010 then the macro should populate dates from cell B2-09/07/2010, B3-10/07/2010, B4-11/07/201012/08/2010. till the last date. Thanks for your time, Looking for your help to proceed further. Thanks again, Sharma On Tue, Jul 27, 2010 at 9:39 AM, Vasant vasant...@gmail.com wrote: Hope this is works... Regards Vasant On Tue, Jul 27, 2010 at 4:22 PM, amrahs k amrahs...@gmail.com wrote: Hi Dilip, I have attached the sample file with my query. Please look into this and help me to proceed further since i have left with only one working day. Looking for your help, Thanks in Advance, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards Vasant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards Vasant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http
Re: $$Excel-Macros$$ Help Required!
Dear Dilip, First I would like to wish you Merry Christmas and Looking forward to continued success with you! Advance Happy New Year 2010 for you and your Family! Thanks for your efforts! Regards, Sharma On 12/24/09, Dilip Pandey dilipan...@gmail.com wrote: Dear Sharma Ji, Merry Christmas Attached is the revised solution. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/23/09, amrahs k amrahs...@gmail.com wrote: Hi Dilip, Good Afternoon! I just wanted to follow up with the below email. Any updated on this sir? Thanks Regards, Sharma On 12/21/09, amrahs k amrahs...@gmail.com wrote: Dear Dilip, Yes. Please go ahead with the revised solution since it looks perfect. Good job sir. Thanks a lot for your efforts. Regards, Sharma On Mon, Dec 21, 2009 at 8:01 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear SharmaJi. Attached is the revised solution for you with action item at your end. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Dec 21, 2009 at 1:43 PM, amrahs k amrahs...@gmail.comwrote: Hi Dilip, Thanks for looking into this. I have added my comments in the attached spreadsheet. Thanks again for your efforts! Regards, Sharma On 12/19/09, Dilip Pandey dilipan...@gmail.com wrote: Dear SharmaJi, Attached file may help you. Thanks, Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/19/09, amrahs k amrahs...@gmail.com wrote: Dear Team, I have attached sample excel file with my query. Can anyone help me to resolve the same. Is there any macro to do this? Thanx in Advance. Sharma -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help Required!
Dear Dilip, Yes. Please go ahead with the revised solution since it looks perfect. Good job sir. Thanks a lot for your efforts. Regards, Sharma On Mon, Dec 21, 2009 at 8:01 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear SharmaJi. Attached is the revised solution for you with action item at your end. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Dec 21, 2009 at 1:43 PM, amrahs k amrahs...@gmail.com wrote: Hi Dilip, Thanks for looking into this. I have added my comments in the attached spreadsheet. Thanks again for your efforts! Regards, Sharma On 12/19/09, Dilip Pandey dilipan...@gmail.com wrote: Dear SharmaJi, Attached file may help you. Thanks, Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/19/09, amrahs k amrahs...@gmail.com wrote: Dear Team, I have attached sample excel file with my query. Can anyone help me to resolve the same. Is there any macro to do this? Thanx in Advance. Sharma -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help Required!
Dear Dilip, I believe that you might have answered my query already but somehow it was missed or deleted in my folder. Could you please share it again so that I can go through it again. Thanks for your efforts and suggestion towards this. Regards, Sharma On Wed, Jun 3, 2009 at 7:36 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Mr. Sharma, I have already answered this and replied back with a query to you. Can you please go back and check out the chain email on this topic. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jun 3, 2009 at 2:12 PM, amrahs k amrahs...@gmail.com wrote: Dear Team, Could any one suggest me to solve this task. Thanks, Sharma On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi Dilip Sir, Can you please look into this query. Regards, Harmeet -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Sat, May 30, 2009 at 4:58 PM Subject: $$Excel-Macros$$ Help Required! To: Harmeet Singh harmeet.hew...@gmail.com Cc: excel-macros@googlegroups.com Hi Harmeet, I have comeup with new task and I have explained the query in the attached spreadsheet. I want the macro to automatically put the date as per the requirement in the column I and J respectively. Thanks for your time. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Required!
Dear Team, Could any one suggest me to solve this task. Thanks, Sharma On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi Dilip Sir, Can you please look into this query. Regards, Harmeet -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Sat, May 30, 2009 at 4:58 PM Subject: $$Excel-Macros$$ Help Required! To: Harmeet Singh harmeet.hew...@gmail.com Cc: excel-macros@googlegroups.com Hi Harmeet, I have comeup with new task and I have explained the query in the attached spreadsheet. I want the macro to automatically put the date as per the requirement in the column I and J respectively. Thanks for your time. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Required!
Hi Harmeet, Any update on the below one. Whether this can be done through macro or not? Please let me know am waiting for your valuable suggestion. Regards, Sharma On Sat, May 30, 2009 at 4:58 PM, amrahs k amrahs...@gmail.com wrote: Hi Harmeet, I have comeup with new task and I have explained the query in the attached spreadsheet. I want the macro to automatically put the date as per the requirement in the column I and J respectively. Thanks for your time. Regards, Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Required!
Hi Bala, Thanks for your help and efforts provided for the below task. Regards, Sharma On Fri, May 29, 2009 at 3:26 PM, bala bal...@gmail.com wrote: Hi find the code below Sub test() Dim strAddress As String strAddress = Range(B65536).End(xlUp).Address Range(B3).Select While ActiveCell.Address strAddress If ActiveCell.Offset(0, 89).Value Labor Then MsgBox Cell ActiveCell.Offset(0, 89).Address is empty End If ActiveCell.Offset(1, 0).Select Wend End Sub Regards Bala On May 29, 12:53 pm, amrahs k amrahs...@gmail.com wrote: Hi Harmeet, I just want a macro for validating a particular column in the attached spreadsheet. The requirement is as follows- If column B4:B has S.No. 1,2, and so on then it should check for the corresponding column CM4 in the same row. Whether the cell is contain value Labor or not. If it is blank then i need a msgbox for the same (ie) cell value is empty. Similarly for the next S.No. 2, 3 and so on. (Note: if you refer the S.No. 3 it seems very clear that the cell CM8 is empty does not contain Labor. for this case i need the macro should give an alert that cell value is empty! I need your extreme help towards this since it is very urgent to my project. Thanx in advance. Regards, Sharma Sample.xls 437KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Required!
Hi Harmeet, This is what i am exactly looking for. Thanks a lot. Keep rocking. Regards, Sharma On Fri, May 29, 2009 at 8:53 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: On Fri, May 29, 2009 at 1:23 PM, amrahs k amrahs...@gmail.com wrote: Hi Harmeet, I just want a macro for validating a particular column in the attached spreadsheet. The requirement is as follows- If column B4:B has S.No. 1,2, and so on then it should check for the corresponding column CM4 in the same row. Whether the cell is contain value Labor or not. If it is blank then i need a msgbox for the same (ie) cell value is empty. Similarly for the next S.No. 2, 3 and so on. (Note: if you refer the S.No. 3 it seems very clear that the cell CM8 is empty does not contain Labor. for this case i need the macro should give an alert that cell value is empty! I need your extreme help towards this since it is very urgent to my project. Thanx in advance. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: Help required
Hi Dave and Team, Thanks for the help provided. I have done this successfully with out any issues. once again thank you all for your valuable and swift response as well. Regards, Sharma On Wed, May 13, 2009 at 10:50 PM, Fabio Lemos flnle...@gmail.com wrote: Hi, It's possible to use Validation, but it need to be custom and you'll need a auxiliar column. But Validation doens't have the possibility of warning in some cases and error in other. I created a solution that uses validation for the main rules and for the first 0 I used conditional formating. see the attached file. Regards! 2009/5/13 amrahs k amrahs...@gmail.com Hi Harmeet, I have attached one sample workbook that contains a query for data validation. I just need a macro for the same. Thanks for your help. Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.com wrote: Hi, Please see attached file. On Wed, May 6, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote: Hi Team, I need your help it is very urgent! Thanks, Sharma -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Wed, May 6, 2009 at 5:33 PM Subject: Help required To: gyanjai...@gmail.com Hi Jain, I have attached the sample spreadsheet that i was working upon for my project. The requirement would be- Count the data that has been entered in each cell under coulumn D6:D17, F6:F17, H6:H17 and so on. (every alternate column) I want the macro to evaluate the total count of each alternate coulumn though I have few conditions. condition 1: count all the data entered in each cell (text or numeric value) condition 2: do not count the data NA It would be helpful if the macro populated the result in a message box- Ex: The Total Count is 13 (The attached document has 17 data in the range D6:D17, what i want to exclude the value NA and produce the result as 13). similarly for every alternate column. I believe you could do this since am not familiar with VBA macro. Thanx in advance. Regards, Sharma -- Thanks Regards, Harmeet Singh -- Fabio L Lemos email: flnle...@gmail.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: Help required
Hi Harmeet, Please find the attached sample workbook that contains a simple query for my project. Thanx in advance. Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi, Please see attached file. On Wed, May 6, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote: Hi Team, I need your help it is very urgent! Thanks, Sharma -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Wed, May 6, 2009 at 5:33 PM Subject: Help required To: gyanjai...@gmail.com Hi Jain, I have attached the sample spreadsheet that i was working upon for my project. The requirement would be- Count the data that has been entered in each cell under coulumn D6:D17, F6:F17, H6:H17 and so on. (every alternate column) I want the macro to evaluate the total count of each alternate coulumn though I have few conditions. condition 1: count all the data entered in each cell (text or numeric value) condition 2: do not count the data NA It would be helpful if the macro populated the result in a message box- Ex: The Total Count is 13 (The attached document has 17 data in the range D6:D17, what i want to exclude the value NA and produce the result as 13). similarly for every alternate column. I believe you could do this since am not familiar with VBA macro. Thanx in advance. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Sample.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Fwd: Help required
Hi Harmeet, I have attached one sample workbook that contains a query for data validation. I just need a macro for the same. Thanks for your help. Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi, Please see attached file. On Wed, May 6, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote: Hi Team, I need your help it is very urgent! Thanks, Sharma -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Wed, May 6, 2009 at 5:33 PM Subject: Help required To: gyanjai...@gmail.com Hi Jain, I have attached the sample spreadsheet that i was working upon for my project. The requirement would be- Count the data that has been entered in each cell under coulumn D6:D17, F6:F17, H6:H17 and so on. (every alternate column) I want the macro to evaluate the total count of each alternate coulumn though I have few conditions. condition 1: count all the data entered in each cell (text or numeric value) condition 2: do not count the data NA It would be helpful if the macro populated the result in a message box- Ex: The Total Count is 13 (The attached document has 17 data in the range D6:D17, what i want to exclude the value NA and produce the result as 13). similarly for every alternate column. I believe you could do this since am not familiar with VBA macro. Thanx in advance. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Sample.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Fwd: Help required
Thank you very much Harmeet! Just curious to know whether we can done it through VBA coding? because i suppose to apply this formula in all the checklists its around 50 workbooks. Any ways thanks for your swift response! Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi, Please see attached file. On Wed, May 6, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote: Hi Team, I need your help it is very urgent! Thanks, Sharma -- Forwarded message -- From: amrahs k amrahs...@gmail.com Date: Wed, May 6, 2009 at 5:33 PM Subject: Help required To: gyanjai...@gmail.com Hi Jain, I have attached the sample spreadsheet that i was working upon for my project. The requirement would be- Count the data that has been entered in each cell under coulumn D6:D17, F6:F17, H6:H17 and so on. (every alternate column) I want the macro to evaluate the total count of each alternate coulumn though I have few conditions. condition 1: count all the data entered in each cell (text or numeric value) condition 2: do not count the data NA It would be helpful if the macro populated the result in a message box- Ex: The Total Count is 13 (The attached document has 17 data in the range D6:D17, what i want to exclude the value NA and produce the result as 13). similarly for every alternate column. I believe you could do this since am not familiar with VBA macro. Thanx in advance. Regards, Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---