How to put Prefix in filenames on all files in folder with Modified Date

**junmishima** · 12-22-2013, 10:53 PM

Hi all

i wanted to put a prefix on all files in a folder with the files Modified Date.

How can i do it with Excel VBA?

Before
Filename
11131101.xls
11131102.xls

Modified Date
11/1/2013 7:54PM
11/2/2013 7:46AM

After
Filename
0111131954-11131101.xls
0211130746-11131102.xls

Modified Date
11/1/2013 7:54PM
11/2/2013 7:46AM

format of the PREFIX ddmmyyHM-

Actual View:
below are the Before and After of the filename structure i wanted to get.
Before
before.jpg
After
after.jpg

Thanks in advance for all the help

BTW: i'm using Excel 2003

jun

**junmishima** · 12-23-2013, 12:36 AM

ok.. i did a little bit of modification based on this code that i find..

Add Date as Suffix

Please Login or Register  to view this content.

but every time i run the above code i receive an error

"Run time error = 53
File Not Found"

and Debug it stop at the replace process..
the file indeed existed in a folder.

can anyone advise what is wrong?
p/s: i used this to get information for the GetDetailsOf GetDetailsOf infor
thanks

**junmishima** · 12-26-2013, 08:47 PM

It seems after posting in here i got really motivated and pushed myself to try to find the solution and i DID

with the help of Mr Google i manage to find something similar as what i wanted and get it to work.

here is my codes which i modified from the 2 reference links below this reply:

Please Login or Register  to view this content.

it seems to work for me, so hope that it will helps someone else along the way.

Noted that the code above i modified from the reference below to fit my needs..

Rename Files in Directory

Folder Selection Dialog Box

FileDateTime Syntax

and i think i'll "SOLVED" this thread