• 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
Trouble with Lists in Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Trouble with Lists in Excel


  • Subject: Trouble with Lists in Excel
  • From: "Justin Laden" <email@hidden>
  • Date: Wed, 2 Jan 2008 10:37:33 -0500

I'm still having difficulty dealing with lists in Excel--I'm able to
repeat through and modify lists when I create (initialize out of the
blue) them in Script Editor, but when I copy columns from Excel into
lists, my attempts to modify them are thwarted by an error.

Here is one example:

repeat with i from 1 to (descriptionRange)
   copy text "^[a-zA-Z][0-9]{4}" in item i of descriptionRange with
regexp to item i of jobNumRange
end repeat

My interest is to modify one list item by item, as each item is
modified, copy the result into another list.

Is the problem that I'm asking Excel to do the work?  Does the Finder
need to do it?
 _______________________________________________
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

  • Prev by Date: Saving a File to a Windows Volume
  • Next by Date: Macworld SF Netter's Dinner
  • Previous by thread: Saving a File to a Windows Volume
  • Next by thread: Re: Trouble with Lists in Excel
  • Index(es):
    • Date
    • Thread