Re: how to empty clipboard contents?
Re: how to empty clipboard contents?
- Subject: Re: how to empty clipboard contents?
- From: Walter Ian Kaye <email@hidden>
- Date: Mon, 22 Mar 2004 15:40:40 -0800
At 03:21p -0800 03/22/2004, Paul Berkowitz didst inscribe upon an
electronic papyrus:
On 3/22/04 2:47 PM, "Walter Ian Kaye" <email@hidden> wrote:
> This part:
>
>> Select Range "R12C1:R2513C2"
>> CopyObject Selection
>> Activate Window "FILENAME.xls"
>> Paste
>
> ...should be replaceable with something which transfers the range
> contents directly to the destination sheet. If you can't find a VBA
> command with the functionality of the XLM COPY() command, then you
> should be able to just 'Evaluate' the XLM (aka Excel 4.0 Macro)
> command.
You don't need VBA or Evaluate: it's all in the AppelScript Dictionary.
set theRange to Value of Range "R12C1:R2513C2" of ActiveSheet -- a list
of lists
Activate Window "FILENAME.xls" -- if you really want to
set Value of Range "R1C1:R2502C2" of ActiveSheet to theRange
Does 'Value' include formulas and formatting? (I ask because Excel
has always made distinctions between them.)
thanks,
-Walter
_______________________________________________
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.