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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nigel RS" wrote in message
...
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

Thanks Don, simple when you know how!!

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nigel RS" wrote in message
...
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