Re: more Ms-Excel help !!
Re: more Ms-Excel help !!
- Subject: Re: more Ms-Excel help !!
- From: Craig Sutherland <email@hidden>
- Date: Fri, 28 Dec 2001 07:31:03 -0600
Not elegant but:
tell application "Microsoft Excel"
set b to Formula of Cell ("A1") of Worksheet ("sheet1") of Workbook
("prova2.xls")
set Formula of Cell ("A1") of Worksheet ("sheet1") of Workbook
("proval.xls") to b
end tell
This assumes both workbooks are open.
HTH
Craig
On Friday, December 28, 2001, at 04:15 AM, rhyme wrote:
>
First of all thank you for helping me !
>
Now i've got another problem to resolve !!!
>
Can i tell excel to copy a cell in a worksheet to a cell in a
>
worksheet in
>
an other workbook ??
>
For example if i have 2 workbook "prova1.xls" and "prova2.xls"
>
can i
>
copy the cell A1 from the worksheet 2 of prova2.xls and paste to the
>
cell
>
A1 of worksheet 1 fo prova1.xls ???
>
Thank you vary much !!
>
>
ciao !
>
_______________________________________________
>
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.