LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default File available for editing notification

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open old XLS file without receiving notification bolsoi Excel Discussion (Misc queries) 3 November 7th 09 02:51 AM
Notification when file changes Don B Excel Worksheet Functions 0 May 15th 08 03:43 PM
save file notification Dan Excel Discussion (Misc queries) 4 August 19th 07 03:52 PM
can an automated notification (on xls file changes) email can be anat_ny Excel Discussion (Misc queries) 1 July 10th 07 07:16 PM
Is it possible to receive notification of a file update? spavlica09 Excel Discussion (Misc queries) 1 May 8th 06 04:50 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"