In Excel 2004, the value of an empty cell is not 0 (as it was in Excel X and
earlier, rather confusingly, since 0.0. was, and is, something else) but "".
if value of cell "A3" = "" then
--etc.
--
Paul Berkowitz
> From: Brandon Hunt <email@hidden>
> Date: Mon, 25 Sep 2006 20:48:46 -0500
> To: "email@hidden" <email@hidden>
> Conversation: Excel Find an empty cell
> Subject: Excel Find an empty cell
>
> I have writen a script that test a cell and sees if it has
>
>
>
>
>
>
> tell application "Microsoft Excel"
> open workbook workbook file name "users:brandonhunt:documents:TIme
> Sheet.xls"
> if value of cell "A3" is equal to 0 then
> set value of cell "A3" to ((date string of (current date)))
> set value of cell "B3" to ((time string of (current date)))
> else
> set value of cell "a4" to ((date string of (current date)))
> set value of cell "b4" to ((time string of (current date)))
> end if
> close workbook "Time Sheet.xls" saving yes
> --Just for testing
> open workbook workbook file name "users:brandonhunt:documents:TIme
> Sheet.xls"
> end tell
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Applescript-users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/applescript-users/email@hidden
>
> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/applescript-users/email@hidden
This email sent to email@hidden
