Ponjo,
Please use code tags with your code.
You can use active workbook, so that as long as you are on that book, it should work.
If you are opening a workbook which is not open, you need to change the syntax and use open file