Hi,

I will like to know how to run a macro in Excel 97 when I open a a
workbook in excel.
The idea is that once i open a specific file in excel it automatically
runs a macro.
I need urgent help in this one.

Thanks,

Penguin.


--
pinguino2005
------------------------------------------------------------------------
pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833
View this thread: http://www.excelforum.com/showthread...hreadid=374866

Take a look here for a description of a Workbook_Open event macro:

http://www.mvps.org/dmcritchie/excel/event.htm#wb_open

also,

http://cpearson.com/excel/events.htm

In article ,
pinguino2005
wrote:

I will like to know how to run a macro in Excel 97 when I open a a
workbook in excel.
The idea is that once i open a specific file in excel it automatically
runs a macro.
I need urgent help in this one.

I do not need to open the workbook automatically, i need to run the
macro automatically when the workbook is open,

Thanks.

I really need this answer as soon as possible


--
pinguino2005
------------------------------------------------------------------------
pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833
View this thread: http://www.excelforum.com/showthread...hreadid=374866

Take a look at those links again.


pinguino2005 wrote:

I do not need to open the workbook automatically, i need to run the
macro automatically when the workbook is open,

Thanks.

I really need this answer as soon as possible

--
pinguino2005
------------------------------------------------------------------------
pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833
View this thread: http://www.excelforum.com/showthread...hreadid=374866

--

Dave Peterson

Private Sub Workbook_Open()
MyMacroHere
End Sub

Regards

Paul Martin
Melbourne, Australia