Hello,
I would like to run a macro automatically when the Excel file opens.
The macro is written, but what do I do from here?

Thank you,
Chris

Open the Workbook.
Press "Alt + F11"
Press "Ctrl + R"
There will be a window labeled Project - VBAProject
Inside that window there will be listed any open workbooks.
Look under the workbook you're working with to find "ThisWorkbook" an
double-click it.
Another window will appear with "ThisWorkbook (CODE)" in the titl
bar.
There will be two drop down menus near the top of this window.
Drop both of these down and select "Workbook" from the one on the lef
and "Open" from the one on the right.
The body of the window should read:

Private Sub Workbook_Open()

End Sub

Place the code there.

- Piku

--
Message posted from http://www.ExcelForum.com

Add a SUB procedure titled Auto_Open to your module.
execute your code in that SUB or call your routine as
needed. The next time you open the spreadsheet your code
will automatically run.

Holding down the SHIFT key when opening the spreadsheet
will suppress running the Auto_Open routine for testing.

Sub Auto_Open()

myRoutine

End Sub

Sub myRoutine()

'Do your code here

End Sub

>-----Original Message-----
>Hello,
>I would like to run a macro automatically when the Excel
file opens.
>The macro is written, but what do I do from here?
>
>Thank you,
>Chris
>.
>

Pikus-
Thanks! That was the simplest task ever thanks to your detailed
instruction. Much appreciated.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

name your macro
auto_open
see example below



sub auto_open
msgbox("Hello New User")
end sub

Note that this method has been deprecated in favor of using the
Workbook_Open event macro, placed in the ThisWorkbook module:

Private Sub Workbook_Open()
MsgBox "Hello New User" 'no parens needed
End Sub

One significant difference: Event macros will run if the workbook is
opened from code. Automacros require an explicit RunAutoMacro
statement.


In article <013401c3c921$b1309240$(E-Mail Removed)>,
"Drlegend" <(E-Mail Removed)> wrote:

> name your macro
> auto_open
> see example below
>
>
>
> sub auto_open
> msgbox("Hello New User")
> end sub
>

[dhruvbhatt]

Originally Posted by pikus

Open the Workbook.
Press "Alt + F11"
Press "Ctrl + R"
There will be a window labeled Project - VBAProject
Inside that window there will be listed any open workbooks.
Look under the workbook you're working with to find "ThisWorkbook" an
double-click it.
Another window will appear with "ThisWorkbook (CODE)" in the titl
bar.
There will be two drop down menus near the top of this window.
Drop both of these down and select "Workbook" from the one on the lef
and "Open" from the one on the right.
The body of the window should read:

Private Sub Workbook_Open()

End Sub

Place the code there.

- Piku

--
Message posted from http://www.ExcelForum.com

PIKU >>I had the same question. I did the thing you said, but gives me compile error. It says Sub Expected. I am all new to vba excel project. Please help me out. Thanks.