suns11111

Thank you thank you! Will try today!

Hello. I need to track macro usuage and without editing every macro, I could somehow read the "macro nickname" when a macro is run. Goal is to add a line into each macro reading its nickname and add to a variable that I will append to a text file. Any ideas? Thank you in advance! JeffS

John- Thank you for taking the time to reply. I searched the forum and google, but no luck. The Direct Editor does appear to be the way to go. May be a longer process than I was hoping (# of users). Thanks! JeffS

Hello. I have several macros that need their websites updated (for several users). Is there a simple Find Replace method? I have tried outputting the macros in a text file, but would not work. Is there another way that is easier instead of manually doing this on many users? Many thanks! JeffS

Thanks for your reply. I will keep working with Excel to figure out the problem.

Thank you for your replys. I should have mentioned that I have tried to format the information in Excel. The dates are from a old legacy system which Macro Express easily copies and pastes on a Excel spreadsheet, but no matter what i try it will not change formats. Tried Copy and PASTE SPECIAL (Values) and still must see it as text. Meaning I can not change from 05/05/05 to 05/05/2005 or even 2005/05/05. My search will continue! I will keep you posted! Thanks JeffS

I am somewhat familar with Macro Express, but never worked with comparing dates (dd/mm/yy). I have an MS Excel spreadsheet and the macro copies 5 cells (in a row) and <TAB> and gives me the larger number, but does not work with dates it appears. It shows 11/1/05 is greater than 1/1/06.....which is not good. Any ideas to get the greatest (newest) date? Many thanks! Jeff S