I have a template that users open.
They enter details then press a button, enter a file name and save the file.
The macro then switches them to a different file todo some more processing.
I want to be able to switch back to the file they saved.
The command I have is below, but I want to switch to whatever they entered when they saved the file.
The name they save to is 'myfilename' and I want to switch to that one whatever it is called.
Thanks
Code:
windows("test.dotm").activate