How to run macro automatically when file is opened

[Lucieann]

I need to figure out how to automatically run a macro when a file is opened. I have tried, but it seems all that is happening is that the file is opening, but no macro is running. Any help would be appreciated.

Thanks!

 

[fredericofonseca]

Private Sub Workbook_Open()
Dim s As String
s = MsgBox("this is a open of document", vbOKOnly)
End Sub

Private Sub document_Open()
Dim s As String
s = MsgBox("this is a open of document", vbOKOnly)
End Sub

This assuming that it is either a Excel or Word document you are referring to.

It is advisable to give more details of what you are trying to do whenever posting a question.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Chattin]

Call your macro Autpen() if you're using '97 else use the Workbook_Open event