Import with macro the last modified csv data file in a specified folder to excel 2007

I am a totally newbie to programming and I just have a basic understanding on how this stuff works. I am not likely to understand any difficult instructions. If anyone could help me out it would be great.

I have recorded the macro shown below. It imports, sort and saves a specified csv file from a specified folder to a specified folder. I would like to change the macro so that it automatically imports the last modified csv file from C:\Users\aeeibr\Documents\Chronelog\. If this isnt automated I have to rename the file to the name specified in the code everytime I want to import the data.

When I recive the csv file by mail it is automatically saved to the macro import folder with the syntax "yyyy-mm-dd hh-mmchronolog_zones_report"(2012-08-03 20-01chronolog_zones_report) The date and time is added to the filename when the csv file is automatically savded to the folder by outlook when the file is recived.

Hope someone can help me out.

Please Login or Register  to view this content.