• 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
Scripting Excel: simple column copies
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Scripting Excel: simple column copies

  • Subject: Scripting Excel: simple column copies
  • From: David Cake <email@hidden>
  • Date: Tue, 18 Sep 2007 11:45:48 +0800
Hi, everyone. New to the list, been aware of Applescript and used it for things occasionally for years, but I've just hit what I thought would be a simple problem, but that nevertheless has my beat. Scripting Excel is certainly not intuitive.

A client has an an old, working Applescript for Excel 98. It doesn't do anything too complex, mostly just moves a lot of columns around. The time has finally come for them to update their systems and join the 21st century, and that means shifting their scripts to Excel 2004 (I'm not even going to think about 2008 yet - they have some VBA scripts).
So, I've been trying to convert fragments of very old script like
-- select and copy customer name and paste into column 2
«event XCELSLCT» column "F"
«event XCELCpOb» selection
«event XCELSLCT» «class crng» "C2"
«event XCELpast»

which I assume should convert to something like
copy range column "F" destination range "C2"
(I've tried most obvious variations on addressing, and various other ways of expressing what seems to be a similar intent, and all I've ever got is that the message copy range is not understood)
Any idea on what is the natural idiom to convert lots of column copies like the above into modern Applescript?
I have read Microsofts Excel Scripting Guide, and the relevent bits of Mactechs VBA->Applescript guide - I just remain unenlightened.
Cheers
David
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Follow-Ups:
    • Scripting Excel: sample code?
      • From: David Cake <email@hidden>
  • Prev by Date: Re: Printing 2-up duplex in Word (without VBA?) (Was: Scripting Excel: How to find values in cells of kind date)
  • Next by Date: Telling the Finder to only bring one window to the foreground
  • Previous by thread: Ringtones in iTunes 7.4 break database ID retrieval?
  • Next by thread: Scripting Excel: sample code?
  • Index(es):
    • Date
    • Thread