Running code in opened workbook

[Guest]

I have an Excel application that during running opens another workbook which
has some VBA code. How can I run the code in this opened workbook?

At present my application workbook shows a 'sub or function not defined
error when I try to run the code.

' code in my first workbook
Sub ProcessOtherWorkBook

Workbooks.Open Filename:="C:\Accounts.xls"

Call ProcessAccounts <== error here sub or function not defined

End Sub


Cheers

 

[Don Guillett]

Sub pow()
Workbooks.Open Filename:="yourfilename.xls"
Application.Run ("yourfilename.xls!yourmacroname")
End Sub

 

[Guest]

Thanks Don, simple when you know how!!

Sub pow()
Workbooks.Open Filename:="yourfilename.xls"
Application.Run ("yourfilename.xls!yourmacroname")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)