ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Detect open-state of xls from outside Excel (https://www.excelbanter.com/excel-discussion-misc-queries/229922-detect-open-state-xls-outside-excel.html)

Waterloo

Detect open-state of xls from outside Excel
 
Hi
for a time controlled open of Excel files from a C or VB application I need
to know, if a certain xls is already open or not. If already opened, I have
to skip the step in my application. Is there a possibility to get that
particular info? Of course, the xls may be opened on another network client
and therefore I cannot do a simple local search for an Excel session with the
xls in question.

Thanks Wolfgang


Waterloo

Detect open-state of xls from outside Excel
 
Sorry for my superfluous question; I just found solution in
http://support.microsoft.com/Default.aspx?kbid=138621
Wolfgang

"Waterloo" wrote:

Hi
for a time controlled open of Excel files from a C or VB application I need
to know, if a certain xls is already open or not. If already opened, I have
to skip the step in my application. Is there a possibility to get that
particular info? Of course, the xls may be opened on another network client
and therefore I cannot do a simple local search for an Excel session with the
xls in question.

Thanks Wolfgang


Waterloo

Detect open-state of xls from outside Excel
 
Sorry for my superfluous question; I just found solution in
http://support.microsoft.com/Default.aspx?kbid=138621
Wolfgang

"Waterloo" wrote:

Hi
for a time controlled open of Excel files from a C or VB application I need
to know, if a certain xls is already open or not. If already opened, I have
to skip the step in my application. Is there a possibility to get that
particular info? Of course, the xls may be opened on another network client
and therefore I cannot do a simple local search for an Excel session with the
xls in question.

Thanks Wolfgang



All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com