Re: Getting list of open files in Excell
Re: Getting list of open files in Excell
- Subject: Re: Getting list of open files in Excell
- From: Ehsan Saffari <email@hidden>
- Date: Fri, 10 Aug 2001 17:24:33 -0600
On 10/08/2001 11:34, Zsolt Magyar <email@hidden> wrote:
>
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"
welcome to the bugzilla ;>
Open Excel's dictionary in your editor, look at the elements of the
application class they all say:
<element name> by numeric index, by name
none says by range. That's why you can't use: get <property> of "every"
<element>
You can only get properties by index and name. So you may want to try
like this:
--------
set winList to {}
tell application "Microsoft Excel"
try
repeat with x from 1 to 666
set end of winList to Name of Window x
end repeat
on error
end try
end tell
--------
cheers
ehsan