Runnng Excel Macro in VB Code

[tcurrier]

I am able to open a new Excel worksheet in my VB code, but I want to
automatically run an Excel macro when it opens.

I tried this code:

xl.Application.Run "personal.xls!activea"
xl.Application.Run "activea"

But it says that it can't find my macro... Does anyone have an idea
how I can tell the program where to find my macro ?

Thanks ! b

[dglienna]

Call it Auto_Open. Read about it here:

http://office.microsoft.com/en-us/as...346281033.aspx