Copying and renaming files based on timestamp VBA

**jr.benk** · 07-01-2011, 04:06 PM

Hi all,
I'm pretty new to using Excel macros and programming in VBA, so I could really use some help. I think I have a fairly complicated problem as well. I have a lot of .txt files that need to be copied from an SD card, renamed, and pasted into certain folders. I don't know if this is possible, but what I need is for the files to be named according the the time stamp associated with each file, or if its possible to organize the files by when they were created and then name them sequentially. I want the macro to prompt the user where the files are on the SD card and where they want the folders to be created. After that, the files need to be pasted into the folders.
Any help/additional ideas would be greatly appreciated.
Regards,
Ben

**snb** · 07-01-2011, 04:45 PM

Basically the code to move files:

If Q is the driveletter of the SD card and E the drive you want the files to be copied to:

Please Login or Register  to view this content.

**jr.benk** · 07-06-2011, 11:26 AM

Originally Posted by snb

Basically the code to move files:

If Q is the driveletter of the SD card and E the drive you want the files to be copied to:

Please Login or Register  to view this content.

Does that code assume that the name of the file is known? The machine im using to acquire data assigns a random number/letter combination to each file. I was hoping to be able to identify which file I want by entering the time it was created, then extract the data from the SD card. Or to select the 12 newest files created on the SD card and rename those in a specific order.