Okay. The situation's basically this: I have a local folder under the name C:\Program Files\Local and a destination folder called C:\Program Files\Destination. Every day, a new .TXT file will be placed inside the local folder.
Basically I need a application/script of sorts to be able to do the following-
1) Rename that .TXT by stamping a date in front of the current file's name and changing the format into a .GDB (example, office001.txt is renamed into 091109office001.gdb (DD/MM/YY))
2) Transfer the renamed file into the destination folder ( C:\Program Files\Destination).
Doesn't matter what order it happens. It can be transferred, THEN renamed, or the other way round.
For a bonus function, if possible, I would like to set a limiter to the number of files the Destination folder can contain. If the total amount of files inside the Destination folder > 2, the 3rd and the oldest file must be deleted.
I'm really desperate for a solution as my forte isn't in this field, and I was assigned this task as I was the most savvy within the department. I have wasted too much time on it already and need to move on fast.
I apologize for getting so straight to the point, and I would heavily appreciate answers that are usable from the copy.
Both batch files and VB, VB.net files are welcome.