Re: Re: Excel Find an empty cell
Re: Re: Excel Find an empty cell
- Subject: Re: Re: Excel Find an empty cell
- From: Brandon Hunt <email@hidden>
- Date: Tue, 26 Sep 2006 00:02:28 -0500
- Thread-topic: Excel Find an empty cell
I worked on this and changed my method of finding the empty cell now I know
the empty cell I need to fill this cell with the date and the cell next to
it with the curent date here are two tidbits of code to work with
--To Find The Cell
tell application "Microsoft Excel"
open workbook workbook file name "users:brandonhunt:documents:TIme
Sheet.xls"
find of range "A:A" what ""
end tell
--To insert date and time into two cells respectivly
tell application "Microsoft Excel"
open workbook workbook file name "users:brandonhunt:documents:TIme
Sheet.xls"
set value of cell "a1" to (date string of (current date))
set value of cell "b2" to (time string of (current date))
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