Results 1 to 2 of 2

Thread: Apple Script

  1. #1
    Apple Script

    Member Since
    Nov 13, 2009
    Posts
    4
    Post Apple Script
    Hi guys! Well I'm pretty new at apple script and I was wondering if it would be capable of printing an excel spread sheet and updating it to the current day. So for example I have an excel spreadsheet with a "payment plan" type thing for someone who has bought land from me. I mail them an updated copy of their payment history every month. I have the spread sheet set up so that it show's their payments until it's paid off and I just want it to print to the current month. Do you know if this can be done and how I should try to do it?

  2. #2
    Apple Script
    nabl's Avatar
    Member Since
    Dec 13, 2007
    Location
    United States of America
    Posts
    256
    Specs:
    2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09
    Is the date you want to change part of the spreadsheet? If so, I don't think Applescript is necessary; you should be able to do it with a function. Just set the value of the cell to =TODAY() and then set the cell format to the date format you desire. Then, whenever you open it up to print it, it will automatically update the date to that day's.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Apple script
    By Anima Rani in forum OS X - Development and Darwin
    Replies: 4
    Last Post: 10-17-2012, 03:10 AM
  2. apple script
    By castor in forum Switcher Hangout
    Replies: 0
    Last Post: 11-20-2011, 12:56 PM
  3. help with apple script
    By sootom in forum OS X - Operating System
    Replies: 0
    Last Post: 11-08-2011, 04:03 PM
  4. Is apple script what I need?
    By davedave in forum OS X - Apps and Games
    Replies: 0
    Last Post: 03-11-2009, 03:11 AM
  5. syncing ratings between AAC and Apple Lossless iTunes libraries using Apple Script
    By nick_harambee in forum iPod Hardware and Accessories
    Replies: 0
    Last Post: 10-05-2007, 03:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •