Call macros from a VB.EXE

[Todd again]

I am calling a macro within an Excel file to run through a
VB.EXE. The call I am making is not going to the right
module or macro. the syntax I'm using is :
objXLABC.Run "Module2.test". What am I doing wrong or what
else can I do?

 

[jaf]

Hi Todd,
Is objXLABC a specific workbook?


--
John
johnf 202 at hotmail dot com


| I am calling a macro within an Excel file to run through a
| VB.EXE. The call I am making is not going to the right
| module or macro. the syntax I'm using is :
| objXLABC.Run "Module2.test". What am I doing wrong or what
| else can I do?

 

[Guest]

Yes it is a specific workbook I declared and set.

 

[Mike Walker]

The VB.EXE app does this load this specific workbook as the Application.Run
"test" should resolve to any loaded sheet its best to uniquely name this
type of method or function. FYI To see what happens if you create a method
called MSGBOX and your msgbox functionality could be changed to log a msgbox
being called by any other macro with this being sent onwards with a
vba.Msgbox to call the original functional version

Rgds

Mike Walker
(Reply via NG)