Close a .CSV File when the name of the file changes daily
Posted on 2014-03-10
I am trying to cut down on the amount of effort I have to do in getting files into a directory, changing their name and then automatically importing the file data into a Excel spreadsheet.
Each day I get a file called Unsuccessful_Account_Validation[previous days date], for example Unsuccessful_Account_Validation_Mar_10_2014. I can get the file by using vPath = Application.GetOpenFilename("CSV (Comma Delimited) (*.csv),*.csv"
But because the file name is dynamic I cannot close the file using Windows(filename.csv").Activate
Any help you could give me would be greatly appreciated.