On 2002-02-19 13:21, JohnG wrote:
Does anyone know how to call a macro that is in one workbook from another in Excel 2000
On 2002-02-19 13:31, Russell Hauf wrote:
On 2002-02-19 13:21, JohnG wrote:
Does anyone know how to call a macro that is in one workbook from another in Excel 2000
If you have both workbooks open, you can just call the macro by it's name (unless you've declared the Sub/Function as Private).
-rh
On 2002-02-19 14:04, Russell Hauf wrote:
Are both workbooks open? Also, how are you calling your functions? Can you post the code that you are calling FROM and the code that you are calling?
Thank you,
-rh
On 2002-02-19 14:52, Russell Hauf wrote:
Try this:
Application.Run ("CallTest.xls!CallTestMacro")
-rh