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
• Delivered-to: email@hidden
• Delivered-to: email@hidden
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:user-agent:date:subject:from:to:message-id:thread-topic:thread-index:mime-version:content-type:content-transfer-encoding; b=LcwIoQTBZfG9FJRD/eLRggc5j1SaABoA03irba1Ant+0lxQ8pBLFAcaBS2/cm30RZzNqnOq5ZFGkEaeon95xY8hKChVbWkqJ8fst+Iqan2H0lqD8X8Le0me26k+D5D8uSualFOepY9oTGH4CqqPbchPtwMrLTiRbopLTK35vQ3s=
• Thread-index: AcbhKParNQf+Lk0cEduhCQAWy5SHFQ==
• Thread-topic: Excel Find an empty cell
• User-agent: Microsoft-Entourage/11.2.5.060620

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:
http://lists.apple.com/mailman/options/applescript-users/email@hidden

This email sent to email@hidden

• Follow-Ups:
  • Re: Excel Find an empty cell
    • From: Paul Berkowitz <email@hidden>

• Prev by Date: Re: OT: formal prefixes
• Next by Date: Re: Parsing quoted text
• Previous by thread: Re: Excel Find an empty cell
• Next by thread: Re: Excel Find an empty cell
• Index(es):
  • Date
  • Thread