I have about a 1000 files in the following format:
  • YYYYMMDD_HHMM - Hourly.csv
  • YYYYMMDD_HHMM - 5min.csv


For example:
  • 20150701_1259 - Hourly.csv
  • 20150701_1300 - 5Min.csv

etc...

Except the timestamp is different for each file. Inside each CSV are various figures but the most important is the timestamp in cell A3 in the form:

DD/MM/YYYY HH:MM:SS

What I need to do is grab the timestamp INSIDE the sheet (always cell A3) and change the file name of that spreadsheet to this timestamp.

I am quite familiar with excel/macros/VBA. However, I am not sure how to go about this outside of excel. I know it has to do with command prompt and most likely creating a Visual Basic code.

If anyone can provide any info on how to start that would be great. I have Visual Studio Express installed but am not very familiar with it but more than willing to learn!

Any help is much appreciated.

I can provide a sample csv file for both 5Min and Hourly.

Cheers