Re: Export an Excel Chart
Re: Export an Excel Chart
- Subject: Re: Export an Excel Chart
- From: "Patrick D. Fox" <email@hidden>
- Date: Tue, 27 Jul 2004 11:24:14 -0700
Hi Lara:
Here is a technique I've used in the past with Microsoft Office X:
tell application "Microsoft Excel"
Activate
-- area of spreadsheet that gets copied to the clipboard as a graphic
CopyPicture Range "R1C27:R20C34" Appearance xlScreen
end tell
tell application "GraphicConverter"
activate
new image from clipboard
save window 1 in alias fileName as JPEG
close window 1
end tell
Patrick
>
From: Paul Berkowitz <email@hidden>
>
Date: Tue, 27 Jul 2004 10:58:06 -0700
>
To: AppleScript-Users <email@hidden>
>
Subject: Re: Export an Excel Chart
>
>
On 7/27/04 10:42 AM, "Lara Stone" <email@hidden> wrote:
>
>
> I would like to write an AppleScript script that saves Chart 1 on the
>
> active sheet in Excel as a JPEG file in a folder on the hard drive.
>
> How would I do this?
>
>
Not that I know how to do this, but you're going to have to say whether
>
you're using Excel 2004 or an earlier version. The AppleScript dictionary
>
changed for 2004. It will almost certainly be possible in 2004, and may or
>
may not be possible in X/2001/98.
>
>
--
>
Paul Berkowitz
_______________________________________________
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.