I am trying to write a solution to addressing variables using a string equivalent of their name much like using a key to refer to a member of a collection but without the collection.
The way I have succeeded in doing this is creating a temporary sub at runtime, calling it, then deleting it and this works fine. What I wish to do is to only call the temporary sub if it compiles as if it doesnt it will cause a nasty error since the remaining code that deletes the temporary module will not be run
I hear that something exists for Access but can find nothing for Excel
Any help would be an early xmas present
The way I have succeeded in doing this is creating a temporary sub at runtime, calling it, then deleting it and this works fine. What I wish to do is to only call the temporary sub if it compiles as if it doesnt it will cause a nasty error since the remaining code that deletes the temporary module will not be run
I hear that something exists for Access but can find nothing for Excel
Any help would be an early xmas present