Jump to content
Macro Express Forums

Rename Files


Recommended Posts

Well, I don't have any experience with using the file functions in ME. What I am trying to do is pretty simple. I have over 200 Excel documents. All are named "QMacro Express xxxx" where "xxxx" is the project number... from 0030 to 0260" I basically need to replace the "QMacro Express" portion with "QME". So.. it would read "QME 0030". Simple enough... but how to do? Here is what I have:

<REP3:07:000002:000001:0001:0:01:C:\Documents and Settings\dbarber\Desktop\New Folder><TMVAR2:11:01:00:001:068:><TMVAR2:10:01:01:001:004:><DOFILE:06:NN:C:\Documents and Settings\dbarber\Desktop\New Folder\QMacro Express %T1%.xls>C:\Documents and Settings\dbarber\Desktop\New Folder\QME %T1%.xls><ENDREP>



Repeat with Folder
 Variable Modify String: Delete Part of %T1%
 Variable Modify String: Copy Part of %T1% to %T1%
 Rename File or Files: "QMacro Express %T1%.xls"
Repeat End

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...