I just want to know if any of you can provide a good resource or some insight on how I could do this. This question is not a basic "record macro" thing, it's more than that. Question: I'm making a database for a large set of temperature and heat data from a building with 4 zones. The sensor go through LabVIEW that has calibration equations in it and stores this data every minute into a XLS file, once a wall clock hour is over, the file is saved with 60 points of data and continues this process. The file names are in general, "RM 115 6-15-09-00". The two 00, are the hour they are taken from. In this case, this data is of the midnight hour on 6/15/09 for the zone RM 115. Since I'm trying to automate basically everything, I need to take the name of this file and use it in some subroutines I have already written. One being "Insert Date Header." This will take the date off the filename and fill in the proper cells with the proper time. Another subroutine will take the name of the zone and set it to the sheet name, and potentially to the filename of the newly imported data. Any help would be great! Lastly, I would love to do this work in OS X using FileMaker, but the system this is going on is Windows based.