Use string variable as Object name

Posted to microsoft.public.excel.programming

John[_130_] John[_130_] is offline

external usenet poster

Posts: 11

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run-time error 91: Object Variable or With block variable not set	Ayo	Excel Programming	1	August 17th 09 11:29 PM
Object Variable Not Set Error on Selection object	Jean	Excel Worksheet Functions	3	July 24th 06 06:45 PM
Run-Time error '91': Object variable of With block variable not set	jammin1911	Excel Programming	3	June 6th 06 06:36 PM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM

All times are GMT +1. The time now is 09:46 PM.

Menu

About Us