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

Yea... but I want to generate the command aRecon.Name using strings passed to
a function. My problem is whether there's a way (like with application.run
for macros) to run a string as code.

Thanks,
Ryan

"Halim" wrote:

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