Hi all,

I have produced a code that with a click of a button will run a number of macro's which take specific cells from certain sheets and pastes them into a database of various sheets. To acheive this I needed to use the command to select a certain file named window a number of times.

At the end of this data collection the worksheet is automatically saved in a set location with the filename being a cell reference (shown in code below).

Please Login or Register  to view this content.
The problem I forsee is that if someone modifies there data/worksheet after saving it once then the activate window command will no long work as the file name has been changed.

As the original code line to switch windows is:

Please Login or Register  to view this content.
Could this somehow be changed to =Filename.xls? therefore allowing multiple saves rather than it working just once?

Many thanks in advance.