View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeff.j.griffith@gmail.com is offline
external usenet poster
 
Posts: 22
Default calling a method on a object that you know the string name for.

Check out CallByName. I think it does what you're talking about.


scotty wrote:
say you have an object, and you want to call a method, but that method
name is a string.

is there a way to execute this method?

obviously, you can't do

obj.methodname

need something like

Invoke(obj, "methodname")... to execute that method on the object.