Is there any script that will activate the last workbook opened or any script to assist with the scenario below:
I have script that opens 1 file at a time in specified folder. Once the file is opened my script then opens a new template.xls and then copys everything from the opened file to the new template and saves it with the same file name as the file opened but in a different location. the problem arises when I copy from the open file to the new template, as i need to copy four lots of data on different sheets in the file so i need the macro to be able to recognise the opened file and filp to and fro from it. (ps all the files in the folder have different names at the moment I have to do each file individual but if i could get this script to recognise the opened file I can do all the files at flick of button)
Need any furthe clarification , post me..
Please help
Bookmarks