View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_130_] John[_130_] is offline
external usenet poster
 
Posts: 11
Default 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?