Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control how an Excel file is opened
Using Office 2003 and Windows XP;
Suppose I have a form designed in Excel that the user can save locally (e.g. on their own hard drive or personal network location). Is there any way at all to keep users from opening their saved form directly rather than by using a custom VBScript file that opens the file for them? For example, would it be possible to code an Auto Open in the Excel form files that just closes the file again unless it was opened in a certain manner or by a certain program. Could I code the VBScript loading file to alter something in the Excel file to control this behaviour? Reason being that there are certain things you can do with a VBScript file that cannot be done inside Excel itself. Thanks much for any suggetions/comments/input on this concept. Your help is greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control how an Excel file is opened
If you explained these "certain things", maybe someone can do it in Excel.
NickHK "XP" wrote in message ... Using Office 2003 and Windows XP; Suppose I have a form designed in Excel that the user can save locally (e.g. on their own hard drive or personal network location). Is there any way at all to keep users from opening their saved form directly rather than by using a custom VBScript file that opens the file for them? For example, would it be possible to code an Auto Open in the Excel form files that just closes the file again unless it was opened in a certain manner or by a certain program. Could I code the VBScript loading file to alter something in the Excel file to control this behaviour? Reason being that there are certain things you can do with a VBScript file that cannot be done inside Excel itself. Thanks much for any suggetions/comments/input on this concept. Your help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to check file size everytime an Excel file is opened | Excel Programming | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
Why does my .csv file not appear when opened in Excel? | Excel Discussion (Misc queries) | |||
stop excel file opened as read only if already opened by another u | Excel Programming | |||
How to tell Who Opened Excel File. | Excel Programming |