Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running "String" of Code
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
Running Custom Code if "Entire Workbook" is Selected for Printing | Excel Programming | |||
Stop code from running when I click "Cancel" | Excel Programming | |||
"Casing" the strings for smooth code running | Excel Programming | |||
How can i write a vba code to get string or integer "C15" from $c$15? | Excel Programming |