Hello I need one word macro where what i need is we have invoices on word where description says"for Professional services rendered in connection with the following for the year ended march 31, 2010
after running the macro i need following as it is March 2010 which is still not completed so ended word should get replace with the ending , basically it should compare the date(march 31, 2010) on the description with the system date and choose ended or ending depend on the description suppose if it is December 2009 then it will be ended as December is already past and if it is April 2010 it should be ending Please help me ! Note always dte will be in the same format mentioned above -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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