• 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: Scripting Excel: How to find values in cells of kind date
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Scripting Excel: How to find values in cells of kind date


  • Subject: Re: Scripting Excel: How to find values in cells of kind date
  • From: Andreas Schumacher <email@hidden>
  • Date: Mon, 17 Sep 2007 00:03:59 +0200


Am 16.09.2007 um 20:39 schrieb Michael J. Vinca:

Are your values considered dates to Excel? For example, when you search on "2007" does Gefunden have values such as date "Tuesday, November 28, 2006 12:00:00 AM"? If so, ".06" won't work. You will need to search for "June" instead. Unfortunately, Excel throws an error if the find doesn't find anything, so you have to use a try instead of just expecting "nothing" as the documentation states.

@ Michael J. Vinca: Thanks for your quick answer and the hint with the try command.

Yes, when  I search for "2007" I will get "date "Freitag, 2. Februar 2007 0:00:00 Uhr".
When the cells are formatted as date without text like "19.05.2007" I can't search for a month name, nor for "." or numbers with leading zeros like "02".
Only when the cells in Excel are formatted as date with "text elements" like June, July etc, I can search for them.

Maybe there is a preference to change in Excel.
Or is there a possibility to change the date format in Excel from "23.03.2007" to "March 23, 2007" before performing a search?
Something with the "style"- command?

Thanks, Andreas








 _______________________________________________
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

References: 
 >Scripting Excel: How to find values in cells of kind date (From: Andreas Schumacher <email@hidden>)
 >Re: Scripting Excel: How to find values in cells of kind date (From: "Michael J. Vinca" <email@hidden>)

  • Prev by Date: Re: Scripting Excel: How to find values in cells of kind date
  • Next by Date: Re: Scripting Excel: How to find values in cells of kind date
  • Previous by thread: Re: Scripting Excel: How to find values in cells of kind date
  • Next by thread: Re: Scripting Excel: How to find values in cells of kind date
  • Index(es):
    • Date
    • Thread