> 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".
> 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".
I have a two part question relating to active X for Excel applications.
A) Is there a way to lock out a user from entering/changing data in an excel
spreadsheet while VEE is running.
I have a problem where Engineers are changing test data before VEE sends
the file save or print command.
I can use the hide sheet function, but this doesn't allow the user to
stop tests based upon failing data.
B) I also have a problem when trying to open a file after running a test,
the Excel application freezes up.
I have to perform a CTRL-ALT-DELETE and shutdown Excel before getting
the file to open.
David S. Wilson
RF Technical Manager
Paradigm Wireless, Inc.
*Phone: 949-260-1840 ext.142
* Fax: 949-260-0883
*Email: dwilson@pwscom.com
---
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".