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

I'm not sure what you are trying to do. You have macros containing URLs that need to be changed to other URLs? The macros are all in one PC, all in one Macro File?

 

ME is lacking in global replace and ME3 is lacking Replace within a macro file. I'm guessing you would have to write a macro to:

 

Select each of the affected macros in turn (Find in Macro Explorer using macro name)

Open in the Direct Editor (context menu or Macro menu)

Edit/Search and Replace once in the Direct Editor

Close - go to next macro

 

Hopefully someone will post a better method. Did you search the Forum?

 

You could put all the affected macro names in a text file and Text File Process to work through the list (in conjunction with Find).

 

(edit) There are other ways of handling changing data, by storing in an ini file for example and calling up the URL into a text variable when the macro runs. Ini files are plain text so are easy to edit directly. May be a better route than muddling along with what you currently do if this is an ongoing issue.

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