Jump to content
Macro Express Forums

Recommended Posts

Posted

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

Posted

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.

Posted

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%

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...
×
×
  • Create New...