Setting a workbook name as a variable...

[apeface76]

OK--

I have two workbooks. The first workbook contains information that is copied to the second workbook. I then wish to go back to the first workbook and close it (and then repeat this process with additional workbooks' contents being copied to the second workbook). Should be simple...


Windows("Workbook1").Activate
ActiveWorkbook.Close



HOWEVER-- there are the following restrictions:

*The name of the first workbook changes daily at random.

*The first workbook is a nonExcel document that opens via Import Wizard & is never saved while it's open.

*This process should run without user interference - i.e., no forms that require the name of workbook being typed in by the user.

Any ideas? Many thanks in advance.


*