AnsweredAssumed Answered

vrf Excel data problem

Question asked by VRFuser on Oct 19, 2003
Latest reply on Oct 19, 2003 by VRFuser
> A) Is there a way to lock out a user from entering/changing data in an
>    excel spreadsheet while VEE is running.

Nope. Not like you want. You can try disabling selection, but I doubt that
will work - it will mess up your script if you do anything with Select,
Selection, CurrentSelection, Activate, ActiveCell... and probably others
too.

I 'spose you could enable it, enter data, then disable it real quick before
anybody can type anything in. Lookup EnableSelection. You know what - you
could probably lock the cells that your data is going in to. VEE could
unlock them, write, and relock them. That's probably your best bet. Lookup
the Locked property of the Range object. The sheet must also be protected.
Check the Protect method of the Worksheet object.

> B) I also have a problem when trying to open a file after running a
>    test, the Excel application freezes up.

Not freezes up, is busy. Servicing VEE. You can either shut down VEE or use
a process killer to nuke Excel. Once nuked, any references VEE holds to
Excel will become invalid though.
-SHAWN-


---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes