Use string variable as Object name
I'd like to use a string variable as an object's name. Is this possible. For example:
Dim strApp As String
Dim i As Integer
For i = 1 To 3
strApp = "xApp0" & intLaunchNo
Set strApp = New Excel.Application
I know this does not work as above. Any way I can get strApp to serve as the new excel object's name?
|