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: Nigel Smith <email@hidden>
- Date: Fri, 22 Aug 2003 17:04:50 +0100
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!!!
_______________________________________________
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.