Jump to content
Macro Express Forums

Question About Renaming Folders


cita
 Share

Recommended Posts

I i have a list lets say 700 names on it. in exampel win exel.

 

1 . My macro starts up a .bat fil and makes a folder.

 

2 . After this my macro gets in the exel list copys a name from there and goes to where i made my new folder....

 

Here is my problem!

Now i want to use the rename/folder funktion with the PAST or Ctrl v command with the rename/folder funktion. That paste the name from the list and renames my new folder.

 

Plz help

Link to comment
Share on other sites

Got a mail from

Insight Software Solutions, Inc

 

 

After you copy the name to the clipboard, save the clipboard contents to a text string variable such as T1. Use the Variable Set String command, Set Value from Clipboard option. In the Rename Folder command, insert %T1% as the New Name. This will insert the name copied from Excel.

 

Thanks,

Stan Jones

Insight Software Solutions, Inc.

Link to comment
Share on other sites

You might try something like this:

 

Change Directory/Folder: c:\name\of\directory\you\want\to\start\in

Copy value from Excel spreadsheet

Variable Set String from Clipboard into %Tx%

Program Launch: <.bat file that creates folder>

Delay 1 Second (I found that without this delay, the Rename Folder command executed too soon.)

Rename Folder: c:\name\of\directory\you\want\to\start\in\%Tx%

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...