Re: $$Excel-Macros$$ Sum Product Sheet
Hi, Please find some more example on sum product. Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com wrote: http://www.bygsoftware.com/Excel/functions/sumproduct.htm http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ http://www.exceluser.com/explore/sumproduct_11.htm http://www.excelhero.com/blog/2010/01/the-venerable-sumproduct.html www.maysstuff.com/*excel*/*sumproduct*.xls On Tue, Oct 18, 2011 at 10:49 AM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Dear Sirs, Please provide me sumproduct functions sheet which having different example in it. @Noorain Ansari sir, Looking your help also. Thanks Regards, Ankit -- -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- 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 -- B.N Chetan kumar -- -- 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 Sumproduct.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Paste into a Named Range
Hi Don Further to your suggestion of using the offset etc. I have included in attached workbook, but if I drag a number into column A it places it where I place it and not in next available row. Would you mind checking and see if I have this set up correctly. When fixed I can use recorder to get code. Thanks and regards Charlie Harris On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose swch...@gmail.com wrote: Hi Don and ChilExcel Thanks for info. Don like earlier I have not put enough info. I should learn from this. See attached workbook with comments. Thanks, apologies and regards Charlie Harris On Tue, Oct 18, 2011 at 12:29 PM, dguillett1 dguille...@gmail.com wrote: If you have a defined name range such as myrng defined using this, then if you drag to col A it will extend the named range to accommodate the new data. assumes numbers. If numbers in col A, use 99 or any number greater than you might use =OFFSET(Sheet1!$A$2,0,0,MATCH(,Sheet1!$A:$A),2) Don Guillett SalesAid Software dguille...@gmail.com *From:* Cab Boose swch...@gmail.com *Sent:* Monday, October 17, 2011 5:57 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Paste into a Named Range Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but not successful. Thanks Charlie Harris -- -- 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 PasteToNamedRg.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Sum Product Sheet
Dear Ankit, Please find attached sheet of SUMPRODUCT Examples. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Oct 18, 2011 at 10:49 AM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Dear Sirs, Please provide me sumproduct functions sheet which having different example in it. @Noorain Ansari sir, Looking your help also. Thanks Regards, Ankit -- -- 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 SUMPRODUCT-WORLD.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ conditional formatting- more than 3
Dear Kuts, Please see attached sheet i hope it help to u Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer If Not Intersect(Target, Range(A1:A10)) Is Nothing Then Select Case Target Case 1 To 5 icolor = 6 Case 6 To 10 icolor = 12 Case 11 To 15 icolor = 7 Case 16 To 20 icolor = 53 Case 21 To 25 icolor = 15 Case 26 To 30 icolor = 42 Case Else 'Whatever End Select Target.Interior.ColorIndex = icolor End If End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Oct 18, 2011 at 9:04 AM, Kuts xavierj...@gmail.com wrote: Hi I am xavier, new to this group. Please help me in conditional formatting i use excel 2003 and it does not allow more than 3 conditions. Someone can help please Many Thanks Xavier -- -- 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 Conditional_Formating_More than 3 in 2003.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Un lock the file.
Hi, I have a password recovery application (Licensed version) but it works only till office 2003. I tried unlocking your file but no success since it's xlsx (2007). If anyone needs any assistance in breaking passwords till xls or any office application till 2003 ver, I can be a help. Thanks, Anish On Mon, Oct 17, 2011 at 9:35 PM, Sam Mathai Chacko samde...@gmail.comwrote: That will only open the sheet / workbook password Noorain :) On Mon, Oct 17, 2011 at 9:29 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jay, Please try through below link. http://www.straxx.com/excel/password.html -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 7:40 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Pls help me in this. -- Forwarded message -- From: jayendra gaurav jayendra.gau...@gmail.com Date: Fri, Oct 14, 2011 at 1:19 PM Subject: $$Excel-Macros$$ Un lock the file. To: excel-macros@googlegroups.com Dear Team, I forgot the password of this file .kindly unlock the same Its very urgent. Regards J.Gaurav -- -- 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 -- J.Gaurav Operation Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- -- 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 -- Sam Mathai Chacko -- -- 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$$ queary about a jpg file into excel or pdf file
Hey Anil, Please find enclosed. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann http://karanxel.blogspot.com/ http://karanxel.wordpress.com/ On Tue, Oct 18, 2011 at 5:28 PM, anil kumar kmr7a...@gmail.com wrote: Dear all, I want to know that can we change a jpg file into excel or pdf for editing according self. I have attached a file for exaple. Thanks Regards Anil -- -- 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 Converted Data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file
Hi Karan, first of all thanks. you have solved my problem. but how i can -- -- 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$$ Extract from date and time
Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formuale. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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$$ Extract from date and time
Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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: [bulk] $$Excel-Macros$$ Extract from date and time
PFA Best Regards Momin Siraj Ahmad From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muhammad Arslan Sent: 18 October 2011 01:32 PM To: excel-macros@googlegroups.com Subject: [bulk] $$Excel-Macros$$ Extract from date and time Importance: Low Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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 DATE-TIME.xlsx Description: DATE-TIME.xlsx
Re: $$Excel-Macros$$ Extract from date and time
Are you SURE that it is TEXT and not time FORMATTED? Don Guillett SalesAid Software dguille...@gmail.com From: Muhammad Arslan Sent: Tuesday, October 18, 2011 4:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extract from date and time Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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$$ Extract from date and time
Is this text string in an Excel Cell? or is it a text string from another source? More importantly, if it is in a cell, and you change the cell format to short date does it change? Are you wanting a cell formula, or a macro? What do you want to do with the separate values once you've extracted them? 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: Muhammad Arslan arslanacca...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, October 18, 2011 5:31:33 AM Subject: $$Excel-Macros$$ Extract from date and time Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formuale. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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$$ Extract from date and time
Hi, Assuming you have the data in cell a1, you can use following two formula for date n time respectively. =DATE(MID(A1,SEARCH(/,A1,SEARCH(/,A1)+1)+1,4),MID(A1,SEARCH(/,A1)+1,(SEARCH(/,A1,SEARCH(/,A1)+1)-SEARCH(/,A1)-1)),LEFT(A1,SEARCH(/,A1)-1)) =TIME(MID(A1,SEARCH( ,A1)+1,SEARCH(:,A1)-SEARCH( ,A1)-1),MID(A1,SEARCH(:,A1)+1,SEARCH(:,A1,SEARCH(:,A1)+1)-SEARCH(:,A1)-1),MID(A1,SEARCH(:,A1,SEARCH(:,A1)+1)+1,SEARCH(M,A1)-SEARCH( ,A1,SEARCH( ,A1)+1))) Sample file attached for your quick review. Regards, DILIPandey On 18 Oct 2011 18:59, Muhammad Arslan arslanacca...@gmail.com wrote: -- -- 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 Extracting Date Time by DILIPandey.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Extract from date and time
Hi, Lot of option you as suggested by many expert. if the data need to extract to 2 different formt.. Use below formualeInt( a1)Date and Mod(a2,1)---time...change the format of cell as required. Happy learning Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan arslanacca...@gmail.comwrote: Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formual. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- -- 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 -- B.N Chetan kumar -- -- 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$$ Schedule Multiple Macros to Auto Run
I have one macr workbook that has several macros. I didn't know if there is a way to have more than one Macro be scheduled to run at a certain when the Macro workbook is opened. I currently have Task Scheduler running to open the workbook and then it runs my macro at a certain time. Here is the code that I currently have for my macro but I would like to have the ability to schedule another one to run. Private Sub Workbook_Open() If Int(Range(LastRun)) Date Then Application.OnTime Date + TimeValue(15:33:00), Vertis_On_Premise_Report End If End Sub Sub Vertis_On_Premise_Report() Range(LastRun).Value = Date 'then the rest of my code -- -- 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$$ queary about a jpg file into excel or pdf file
Hey Anil, Convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/ http://www.freepdfconvert.com/ http://www.simpleocr.com/OCR_Software/Convert_Image/convert_image_to_Excel.asp Through these sites you can convert your image files in excel format but I'll suggest you try this software *Abby Fine Reader 10 Professional Edition *. Download it from the website, because it can convert your images files in one time. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts http://www.myspace.com/singhkaran http://www.linkedin.com/in/singhkarann http://karanxel.blogspot.com/ http://karanxel.wordpress.com/ On Tue, Oct 18, 2011 at 6:01 PM, anil kumar kmr7a...@gmail.com wrote: but -- -- 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