Kenneth Ismert
kismert at gmail.com
Wed Jul 1 12:09:51 CDT 2009
A.D., It won't work. All VB Objects derive from IDispatch. CallByName is a wrapper for IDispatch. Since modules don't implement any class interface, their functions can't be invoked by CallByName. Use Application.Run, which you suggested earlier. -Ken >A.D.Tejpal: >This refers to my post of 27-Jun-2009, placed below. >While response from William is awaited, it would be >nice if other members of this forum could also kindly >conduct a test and confirm whether any success with >using CallByName() function where the called >procedure / function is in a general module.