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: How to find values in cells of kind date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Subject: Scripting Excel: How to find values in cells of kind date
From: Andreas Schumacher <email@hidden>
Date: Sun, 16 Sep 2007 19:14:09 +0200

I am posting the first time here, so please be patient with my question ;)

I want to find cells in Excel 2004, which contain the first day of each month in a time row.

In Excel the cells are formatted like this: 15.06.2007, 16.06.2007

When I make a search like

> find what ".06" I get an error.

when I search just a number like "2007", it's ok.

Can someone please help me?

Here is part of the script:

tell application "Microsoft Excel"

open workbook workbook file name DatenDatei

set Suchtext to ".06"

set Finden to find range "A:A" what Suchtext

set Gefunden to get value of fc

end tell

Thanks very much, 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

Follow-Ups:
- Re: Scripting Excel: How to find values in cells of kind date
  - From: Doug McNutt <email@hidden>
- Re: Scripting Excel: How to find values in cells of kind date
  - From: "Michael J. Vinca" <email@hidden>

Prev by Date: Re: Paths that work fine from AS don't work when launched from the command line
Next by Date: Re: Scripting Excel: How to find values in cells of kind date
Previous by thread: Re: Mail Script not recognizing Account?
Next by thread: Re: Scripting Excel: How to find values in cells of kind date
Index(es):
- Date
- Thread