View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 182
Default Running "String" of Code

you can directly call
Debug.print aRecon.Name
--
Regards,

Halim



"Hokievandal" wrote:

I'm wanting to run code that is generated as a string. For example, I've got
a class module called clsRecon with a property called "Name".

If I write the following code;

Dim aRecon as New clsRecon
aRecon.Name = "Bill"
debug.print aRecon.Name

then out prints Bill to the immediate window. What if I've passed string
variables so that Ive got the following

Dim aRecon as New clsRecon
Dim sType as String, sProperty as String
aRecon.Name = "Bill"
sType = "aRecon"
sProperty = "Name"

debug.print sType & "." & sProperty

of course... I'll just get "aRecon.Name"

how can I use the strings to get "Bill" instead.

Thanks,
Ryan