View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel RS[_2_] Nigel RS[_2_] is offline
external usenet poster
 
Posts: 80
Default Running code in opened workbook

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