Heim
02-18-2008, 05:01 AM
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
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