Getting list of open files in Excell
Getting list of open files in Excell
- Subject: Getting list of open files in Excell
- From: Zsolt Magyar <email@hidden>
- Date: Fri, 10 Aug 2001 15:23:02 +0200
Dear All,
First of all pls reply to me directly as I'm not on the list. Unfortunately
I can take some time for scripting just occasionally.
The task is quite simple. I need to find out if a certain file is already
open in Excel or not.
As I couldn't find a way to check for open files I thought I get a list of
open windows. This approach works fine almost everywhere except in Excel.
First the window class doesn't have a name property, but if I compile a code
like
"get name of every window"
it compiles fine marking name as application keyword even if the window
class doesn't have a name prop.
However when I run the script I get
In e.x Outlook Express the: can make some data into the expected type and
marks the "name" in "get name of every window".
tell application "Outlook Express"
get name of every window
end tell
returns a list containing the titles (or names) of all windows.
Any idea?
Zsolt