New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Development and Darwin Discussion and questions about development for Mac OS X.

Apple Script


Post Reply New Thread Subscribe

 
Thread Tools
cmwarre

 
Member Since: Nov 13, 2009
Posts: 4
cmwarre is on a distinguished road

cmwarre is offline
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?
QUOTE Thanks
nabl

 
nabl's Avatar
 
Member Since: Dec 13, 2007
Location: United States of America
Posts: 256
nabl has a spectacular aura about
Mac Specs: 2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09

nabl is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Shell Script in GeekTool trouble ... | Lazarus + OSX 10.6 ?? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

All times are GMT -4. The time now is 03:55 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?