• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Excel Find an empty cell
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Excel Find an empty cell
      • From: Paul Berkowitz <email@hidden>
  • Prev by Date: Re: Re: OT: formal prefixes
  • Next by Date: Re: OT: formal prefixes
  • Previous by thread: Re: OT: formal prefixes
  • Next by thread: Re: Excel Find an empty cell
  • Index(es):
    • Date
    • Thread