I am reading a book on Excel 2003 VBA programming. It gives a short
synopsis on how to set up the code for the workbook_open macro but
doesn't really go into how to do it. Can anyone help me with this? I
am using Excel 2007. I plan on writing the code on a Vista OS and
implementing it in an XP environment.

Thanks.
R. Tanner

You must place the code in the ThisWorkbook Module. Otherwise, what
specifically did you need help with?

--JP

On May 27, 7:56 pm, wrote:
I am reading a book on Excel 2003 VBA programming. It gives a short
synopsis on how to set up the code for the workbook_open macro but
doesn't really go into how to do it. Can anyone help me with this? I
am using Excel 2007. I plan on writing the code on a Vista OS and
implementing it in an XP environment.

Thanks.
R. Tanner

we answered the same question that you asked in the programming group.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
I am reading a book on Excel 2003 VBA programming. It gives a short
synopsis on how to set up the code for the workbook_open macro but
doesn't really go into how to do it. Can anyone help me with this? I
am using Excel 2007. I plan on writing the code on a Vista OS and
implementing it in an XP environment.

Thanks.
R. Tanner