DISCO.
Try
Set xl = CreateObject("Excel.application")
xl.Application.Workbooks.Open "yourworkbookpath\yourworkbook.xls"
xl.Application.Visible = True
xl.Application.run "'yourworkbookname.xls'!macronametorun"
Set xl = Nothing
This should do exactly what you need.
HTH
---
Message posted from
http://www.ExcelForum.com/