VBA - Open External Files

[daveburton]

Hopefully this isn't too confusing...

So I'm trying to open a outside xls file (File 2) from within a workbook (File 1), copy the contents of File 2 and paste it back into File 1. The only snag is the File 2 is automatiicaly FTP'd to me daily in a custom folder. Everyday a new folder is created, the name of which is the date (ex. 03062014), and a fresh File 2 is dropped. I can write the code if the location of File 2 was constant but in this case every day the path for File 2 changes to a new folder. Anyone know how to work around this?


Thanks, all!

 

[JimSnyder]

If the new folder is in the same directory, you can use a text file to keep folder names and check against them for a new folder.

 

[daveburton]

If the new folder is in the same directory, you can use a text file to keep folder names and check against them for a new folder.

How would I do something like that? I'm pretty new to coding..