Jump to content
Macro Express Forums

Using Variable Set From File To Rename File


patgenn123
 Share

Recommended Posts

I have files I would like to rename using Variable Set from File. I am choosing "Get File Date/Time" with the month/day/Year as Variables N1, N2 and N3.

 

I have a program that strips attachments from my Outlook Inbox and puts them in a folder.

 

The names of the files in this folder are similarly named.

 

For example, 2nd Mortgage Rate Sheet.pdf

2nd Mortgage Rate Sheet-1.pdf

2nd Mortgage Rate Sheet-2.pdf

 

I know I can use wildcards to rename them to something like this:

 

2nd Mortgage Rates N1-N2-N3.pdf(where N1,N2 and n3 is the date of the original file)

 

 

 

Variable Set From File Date/Time

Rename File or Files: " 2nd Mortgage Rates*.pdf"

 

<VFFILE:0:0:T:1:T:2:T:3:F:1:F:1:F:1:C:\My Cabinets\Pat G\Inbox\Broker 2nd Mortgage Rate Sheet*.pdf><DOFILE:06:NN:C:\My Cabinets\Pat G\Inbox\2nd Mortgage Rate Sheet*.pdf>C:\My Cabinets\Pat G\Inbox\2nd Mortgage Rates*N1-N2-N3.pdf>

 

I am really confused as to why this is not working.

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