paperguy Posted January 31, 2009 Report Share Posted January 31, 2009 Hi, I tried searching this issue in the forum but it is hard to do when the search engine won't accept the words 'run' and 'in', even when enclosed in a "" phrase string Heres my issue - I have a macro which in it uses "Run Macro in Variable" extensively. The text string in the variable has multiple occurences of drive-folder locations. I need to use the macro on a different drive and folder. So my idea was to copy the command text from the Direct-Editor and paste it to Notepad. In Notepad I would do a search and replace to enter the new drive-folders I need for the text string. It worked pretty well but when I copied the text back into ME's Direct-Editor the "Run Macro in Variable" text strings were messed up. The text string in the variable uses "|" as a Carriage Return character but when it's pasted into Notepad it gets converted to "□". When viewed with the Scripting Editor any text after the 1st occurence of a "|" is gone. Confused, I tried copying the macro text from the Direct-Editor and then creating a new blank macro and pasting it in Direct-Edit mode. I got the same result, any text after the 1st "|" Carriage Return is missing. I don't want to go through the macro and in every "Run Macro in Variable" in the macro edit the text string dialog box to change the multiple occurences of drive-folder locations. It's just too tedious. I suppose I could write a macro to edit my macro Any ideas on an easier way to do this? Thanks - Stumped Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.