Hi all,
First post here, hoping someone can give me a hand. Ive just finished creating a macro that will create a new workbook and copy relative data over and make it look pretty. I then find out my boss will be renaming the first workbook on a regular basis!!. My code relies on referencing to the original workbook when it comes to copying.
Is there anyway of creating a variable that will refer to the first workbook? Or some way or referencing to the first workbook without actually using its name?
Thanks