Hi all,
I'm writing some test tools in which I will need to
use some simultaneous Excel objects.
As the number of different objects was variable, I
want to create the object variables during the execution of the program without
the need to declare the whole list first.
I found a suitable way doing this using a tmp
variable to create it and then assign it using the 'Set Variable' object to the
name I want.
I now found some 'strange' behavior when recalling
variables via the 'formula' object.
If I recall a variable using formula which is of
the type 'Excel.Application', it will not give the object itself but instead it
returns the TEXT 'Microsoft Excel'...
For type 'Excel.Workbook' it works fine using the
'formula' object.
Also when using the 'Get Variable' both work
fine.
You can look at the attached sample
code.
In the past I have used a lot of 'formula' objects
to pass variables.
Any reason for this
behavior?
Using Win2000/Vee Pro 6/Excel 2000
Thanks,
Jo De Loor.
Newtec Cy
Laarstraat 5
B-9100 Sint Niklaas
Tel: +32 3 780 65 00
Fax: +32 3 780 65 49