How can I check if an Excel document is opened (by Excel) (OpenInsight Specific)
At 29 JAN 2001 05:27:07PM Barry Stevens wrote:
How can I check if an Excel document is opened (by Excel). It is being opened using ShellExecute. Does Shellexecute have any paramater value that basically says.."If the doc is already open, dont attempt to re-open"
Barry
At 29 JAN 2001 06:39PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Looks like you need this :-
http://www.sprezzatura.com/v2i1.html#_Toc438964913
World Leaders in all things RevSoft
At 30 JAN 2001 01:52AM Barry Stevens wrote:
Look, I know this is a hugely dumb question, but, are you refering to the FindWindowByTitle, if so, is the Title what is on the top of the screen showing the document name, so, I set up a string exactly as it show on the top when opened and use that.
If I create a new dll FindWindowByTitle, will that come across ok using the OI Rdk deployment application.
BTW. I tried using osopen to open the doc assuming it would take the else path if it was open…but it didnt, does that seem strange, I thought excel would have some sort of lock on it.
Barry
At 30 JAN 2001 04:13AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Barry,
…refering to the FindWindowByTitle, if so, is the Title what is on the top of the screen showing the document name, so, I set up a string exactly as it show on the top when opened and use that.
Correct.
If I create a new dll FindWindowByTitle, will that come across ok using the OI Rdk deployment application.
We (I?
don't really use the RDK, but declare_fcns() does create repository entities for the dll prototypes you define so the RDK should be able to pick these up.
BTW. I tried using osopen to open the doc assuming it would take the else path if it was open…but it didnt, does that seem strange, I thought excel would have some sort of lock on it.
Yeah, notepad doesn't lock files either - not sure about Word cos I've never tested. Does it create a hidden temp file like Word? Perhaps you could see if this there instead?
World leaders in all things RevSoft
At 30 JAN 2001 04:21AM Oystein Reigem wrote:
]]BTW. I tried using osopen to open the doc assuming it would take the else path if it was open…but it didnt, does that seem strange, I thought excel would have some sort of lock on it.
]Yeah, notepad doesn't lock files either - not sure about Word cos I've never tested. Does it create a hidden temp file like Word? Perhaps you could see if this there instead?
Tried an OSOpen … then … else on a text file
(1) while not opened by Word,
(2) while opened by Word,
(3) while opened and changed by Word,
(4) while opened and changed and saved by Word.
Made no difference. Execution always took the then branch.
- Oystein -
At 30 JAN 2001 09:02PM Barry Stevens wrote:
Thanks Guys
FindWindowByTitle works a treat. RDK picks up OK.
Barry