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 |
Running code in opened workbook
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 |
Running code in opened workbook
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 |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com