Re: [Newbie] MS Excel GUI and Applescript
Re: [Newbie] MS Excel GUI and Applescript
- Subject: Re: [Newbie] MS Excel GUI and Applescript
- From: Eric SURIN <email@hidden>
- Date: Fri, 28 Mar 2003 09:47:21 +0100
I have automated Excel through VB to do a lot of repetitive layout and data
feeding tasks. I need to print each result into a pdf file.
My problem is that in VB the printout command accept less parameters on Mac
than on Windows, especially the PrintToFile parameter is not implemented
(for what reason, I wonder ??).
On OS 9, we had Adobe PDFWriter which printed directly to a pdf file just by
using the printout command. The only problem was naming and placing of
generated files...
I had hope with the new Mac OS X and its integrated Quartz system for
generated PDF. But the f... new printing system of OS X makes it impossible
to print to a PDF file without the intervention of a user (by clicking on
the "save as PDF" button) and is not able to save default printing
parameters as on OS 9. On top of that, PDFWriter is no longer available,
neither Distiller on OS X.
So I turned towards UI scripting, but XL does not accept this.
If you have any idea to print to a PDF file direcly from XL without human
intervention, please help !
Thanks.
Eric
>
On 3/27/03 8:05 AM, "Bill Cheeseman" <email@hidden> wrote:
>
>
>> Is MS Excel GUI scriptable using System Events ?
>
>> I can not simulate clicks on XL menu items and UI Element Inspector does not
>
>> react with MS Excel.
>
>
>
> PreFab UI Browser doesn't recognize UI elements in Excel, either. One must
>
> conclude that Excel does not support accessibility.
>
>
On the other hand, Excel is very scriptable, with hundreds of terms in its
>
dictionary. Unfortunately the dictionary explains nothing at all, so it's
>
hard to figure out what to do. (Tip: if you go to the VB Editor Help, you
>
can check for similarly-named terms there: they're close to identical, and
>
the Help is really excellent at explanations. Then use AppleScript syntax
>
back in AS.) I'm sure you could script Excel to do what you want without the
>
need of UI scripting.
_______________________________________________
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.