• 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: more Ms-Excel help !!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


  • Follow-Ups:
    • Moving Script Debugger's Insertion Point
      • From: Jason Bourque <email@hidden>
References: 
 >more Ms-Excel help !! (From: rhyme <email@hidden>)

  • Prev by Date: Information about DoCommand of iMovie
  • Next by Date: Re: Extracting text from IE (or PageSpinner)
  • Previous by thread: more Ms-Excel help !!
  • Next by thread: Moving Script Debugger's Insertion Point
  • Index(es):
    • Date
    • Thread