• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Export an Excel Chart
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


References: 
 >Re: Export an Excel Chart (From: Paul Berkowitz <email@hidden>)

  • Prev by Date: I cannot even successfully have the Finder make a folder on the Desktop!
  • Next by Date: Re: I cannot even successfully have the Finder make a folder on the Desktop!
  • Previous by thread: Re: Export an Excel Chart
  • Next by thread: I cannot even successfully have the Finder make a folder on the Desktop!
  • Index(es):
    • Date
    • Thread