Code to enter code into a new workbook

[snolze123]

I am using Excel 2003 and I have a workbook that I use to create hundreds of individual reports and when I create each new file I want to enter some VBA code that will run each time the file is opened. How can I enter the following code to the "ThisWookbook" part of each new file?

Private Sub Workbook_Open()
     MsgBox "Hi, thanks for opening " & ThisWorkbook.Name 
End Sub

 

[Domski]

Have a look here: http://www.cpearson.com/Excel/vbe.aspx

Dom