Excel Find an empty cell
Excel Find an empty cell
- Subject: Excel Find an empty cell
- From: Brandon Hunt <email@hidden>
- Date: Mon, 25 Sep 2006 20:48:46 -0500
- Thread-topic: 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:
This email sent to email@hidden