How can AppleScript change the name of a Numbers Table?
I have a folder of summary spreadsheets in which I place summaries of individual files to get totals for the business as a whole. I run this monthly, and have twelve files in the folder, appropriately named "August 2014", "January 2015", etc.
Within each spreadsheet is a table listing the clients individually. I have named the table with the date as part of the title, so the first table is "August 2014 Clients". This is so that when I print the report for distribution, the date is prominently at the top within the title.
My AppleScript takes the August 2014.numbers file, repopulates it with August 2015 data, and renames the file "August 2015.numbers" no problem. But I'd like to have the script automatically rename the table within the spreadsheet so it also reflects the change in year. How do I go about this?
MacBook Pro, OS X Yosemite (10.10.5)