I have a workbook that will need data from another which will be located in the same directory. I need to open this workbook however the filename will be imported daily and be different each time (i.e. 010707.xls, 010807.xls, etc.) The only two files residing in the directory will be the active file and the one that needs to be opened.
Is there a way to assign a variable for the 010707? Currently I have the following and need to manually modify the file name:
Thanks for any help on this,