Excel Macro Automatic

[graciela]

Hello, i want to know how i write an automacro in excel.
The thing is to open a workbook, and automatic execute a
macro, can i help me?

 

[Don Guillett]

try this
Workbooks.Open(workbookname & ".xls").RunAutoMacros xlAutoOpen

 

[Richard Mogy]

Try this:

In VBA, click on This Workbook
create a subroutine

sub Workbook_open()
.....command to run macro.
end sub