Opening a different version of Excel from VBA

[gruntingmonkey]

In short:
Does anyone know if its possible to open a different version of Excel from VBA.

In long:
We have four different version of Excel which you log into by going to:
start, all programs, microsoft access, Excel 2003
start, all programs, SAS, Excel 2003
start, all programs, SAS 4.3, Excel 2003
start, all programs, microsoft office, Excel 2003

I'm trying to automate the whole process but am having difficulty working out how to use the different versions of Excel. To make things more difficult, there is no C drive as we use a virtual client system.

Starting in the last Excel, how would you call the other 3?

Apologies if this is not phrased in the correct way - it made sense to me when I wrote it!

Jess

 

[wigi]

Hello Jess

If you right-click a shortcut in the Start menu, you can see where it points to.
Probably you can use that route to open up an application.

 

[gruntingmonkey]

I'm not able to do that as I work on a Virtual Client System.