Unanswered: Opening multiple instances of graph at same time, but tricky...
i know how i would open multiple instances of a graph that i was sure was going to be opened -
Set gphNew = New Form_gphWhatever
. But would it be possible to do something like that when the object name to be opened is stored in a variable? For example, at the end of the code, the variable strGraph may hold the name "gphSQLOld" or "gphSQLNew"
any way that i could accomplish a
Set gphNew = New "Form_" & strGraph
Obviously the above does not work. I did that kind of stuff with the preprocessor in C, but have no clue how to accomplish this in VBA. thanks for looking. have a great week
Interface can't find the form 'gphSumWeightsOLD' referred to in a macro expression or Visual Basic code.
I think because I'm trying to Set the object to the form, which hasn't been opened yet.
I ALWAYS forget about collections. Thanks for the help. I think it's a step in the right direction. Have a good one.