Re: Mixing Apple Script, Excel and a network
Re: Mixing Apple Script, Excel and a network
- Subject: Re: Mixing Apple Script, Excel and a network
- From: Courtney Moore <email@hidden>
- Date: Mon, 25 Aug 2003 14:41:37 -0500
On 8/22/03 11:04 AM, "Nigel Smith" <email@hidden> wrote:
>
On 19/8/03 18:16, "Courtney Moore" <email@hidden> wrote:
>
>
> What I was trying to say is that Scripting Excel seems to work on machines
>
> that are not authenticating to our server but does not work on machines that
>
> do authenticate (their home directory lives on the server instead of on
>
> their local machine)
>
>
>
> I wonder if Excel is trying to access something in the background and does
>
> not have access to it? ????
>
>
I've finally had some time[1], and had a play with this.
>
>
You can script Excel when it is used in this way, but it will fail as soon
>
as Excel tries to use any VBA -- ie. as soon as you issue any useful
>
command!
>
>
The way I found round this is to delete the "Carbon Registration Database"
>
file from the "Microsoft" folder of ~/Library/Preferences -- you can then
>
launch Excel, which will rebuild that file and work properly. Until the next
>
time...
>
>
That may not prove too useful, however, as file references on a network
>
login are less than reliable. For example:
>
>
--------
>
set fileRef to (choose file) as text
>
>
tell application "Finder"
>
delete alias fileRef
>
end tell
>
--------
>
>
...will fail using a file in your Home documents folder, but will succeed
>
using a file in the machine's /tmp directory.
>
>
So you may have fudge around a lot to get Excel to do what you want...
>
>
Hope that helps,
>
>
Nigel
>
>
[1] In other words, I got tired of users complaining that they were getting
>
weird email messages (thanks, SoBig) and retalliated by repeatedly
>
restarting our main fileserver while getting Remote Authentication and
>
remote home folders working. Complaints? Not any more -- the BOFH is back!!!
>
BWAA-HAA-HAA-HAA!!!
>
Nigel-
Thanks so much for your help. I can't wait to start playing around!
I will let you know how it goes!
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.