Hello Cathy,
> I am currently using HP VEE version 3.0 under windows 3.11. I am using
> VEE with a number of test instruments to perform an automated test
> sequence.
>
> I am relatively new to using VEE, and am seeking to output the results in
> number format (from the HP VEE) to an Excel spreadsheet, for reporting
> purposes.
>
> Does anyone know the best way to do this, or have any pitfalls to avoid?
There's one pitfall I came accross, and it has to do with a bug in the
to/from DDE object. It concerns the Row/Column identifier the object
uses to let Excel know in which cell the data has to be written. If I
am right, it is not possible to directly write something like:
"R",row,"C",column in the item field, and using 'row' and 'column' as
data inputs. In any case, the solution is to make the string "RxCy"
outside the to/fromDDE object (with a To String obeject), add a data
input to it, for example named RxCy and using this variable in the item
field.
This is a known bug, and on the web site of HP you can find information you
need on this subject.
I hope this helps.
--
+----------------------------------------------------------------------------+
| Jaap Schuurmans Philips Semiconductors B.V. |
| E-mail: schuurmn@ehv.sc.philips.com PCALE |
| Seri: schuurmn@nlsce1 Building BE445 |
| Phone: +31-40-27 22058 P.O. BOX 218 |
| fax : +31-40-27 22764 5600 MD Eindhoven, The Netherlands |
+----------------------------------------------------------------------------+
> I am currently using HP VEE version 3.0 under windows 3.11. I am using
> VEE with a number of test instruments to perform an automated test
> sequence.
>
> I am relatively new to using VEE, and am seeking to output the results in
> number format (from the HP VEE) to an Excel spreadsheet, for reporting
> purposes.
>
> Does anyone know the best way to do this, or have any pitfalls to avoid?
There's one pitfall I came accross, and it has to do with a bug in the
to/from DDE object. It concerns the Row/Column identifier the object
uses to let Excel know in which cell the data has to be written. If I
am right, it is not possible to directly write something like:
"R",row,"C",column in the item field, and using 'row' and 'column' as
data inputs. In any case, the solution is to make the string "RxCy"
outside the to/fromDDE object (with a To String obeject), add a data
input to it, for example named RxCy and using this variable in the item
field.
This is a known bug, and on the web site of HP you can find information you
need on this subject.
I hope this helps.
--
+----------------------------------------------------------------------------+
| Jaap Schuurmans Philips Semiconductors B.V. |
| E-mail: schuurmn@ehv.sc.philips.com PCALE |
| Seri: schuurmn@nlsce1 Building BE445 |
| Phone: +31-40-27 22058 P.O. BOX 218 |
| fax : +31-40-27 22764 5600 MD Eindhoven, The Netherlands |
+----------------------------------------------------------------------------+
Email : cspencer@baea.com.au
Subject : Using DDE from HP VEE to Excel under windows
Hello everyone,
I am currently using HP VEE version 3.0 under windows 3.11. I am using
VEE with a number of test instruments to perform an automated test
sequence.
I am relatively new to using VEE, and am seeking to output the results in
number format (from the HP VEE) to an Excel spreadsheet, for reporting
purposes.
Does anyone know the best way to do this, or have any pitfalls to avoid?
Regards,
Cathy Spencer
--------------------------------------------------
British Aerospace Australia
Email: cspencer@baea.com.au
--------------------------------------------------