Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have an c# application that opens Excel files and performs read and write operations. The application ensures that the excel file used for writing is not read only (ReadOnly property of the workbook must be false). When I open a file manually and then try open it through the system, the application can determine that it is read-only and I can send this error to the user and close the workbook (Workbook.Close( false, Missing.Value, Missing.Value) ). The problem arises when I close the manually opened copy of the file. Excel still thinks I'm wanting to use this file even though i've explicitly closed it and presents the user with a message stating that the file can now be opened with read-write access. Clicking the accept or cancel button on this Excel dialog causes the Excel object from my application to become visible. The user could then possibly close this and cause serious havoc in the application. I've managed to set some properties on the Excel application to prevent the user closing the Excel window but I would prefer if the notification window didn't get shown to the user at all. Is this at all possible? TIA, Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open old XLS file without receiving notification | Excel Discussion (Misc queries) | |||
Notification when file changes | Excel Worksheet Functions | |||
save file notification | Excel Discussion (Misc queries) | |||
can an automated notification (on xls file changes) email can be | Excel Discussion (Misc queries) | |||
Is it possible to receive notification of a file update? | Excel Discussion (Misc queries) |