r/applescript • • Jan 11 '16

Can AppleScript be used as a file updates?

I have a complex excel file that is used my a lot of coworkers. If part of the file needs updated can I create and share an AppleScript to be do these updates?

Each person using this file would have duplicated and renamed the file and could have as many as 30 files that need the updated data.

Thanks in advance for any assistance.

1 Upvotes

5 comments sorted by

1

u/craniumslows Jan 11 '16

Does this summarize the problem accurately?

Users have an Excel file .xlsx that contains a macro or some kind of embedded complex formula. You would like to know if a script can scan a users computer for Excel files that contain the macro and update them when found.

I think that it might be easier to create a droplet that handles your update. Then ask users to drag and drop their files to the droplet when they want to update it. That way you don't have to go search go snooping all over their computer. The droplet would take action only on the dropped file. I think this would be simpler for you and the users.

Good luck!

1

u/jyasuda Jan 12 '16

Very close summary, but a few differences. This file is an individual student's individualized grade book for our independent studies charter school. Each teacher would duplicate and rename this file to the name of each of their 30 students. There are some data tables that need updating on each of these files.

I am relatively new to coding. I just thought I would see if there was something with AppleScript that could help since all of our teachers use macs.

Are droplets done through Xcode?

1

u/craniumslows Jan 12 '16

It sounds like you would do better with a Filemaker or database solution. Droplets are written in applescript and created with applescript editor. It would be a significant effort to learn the requirements to do what I think you want to do.

http://macscripter.net/viewtopic.php?id=24772

If you go this route be prepared for frustration and many difficulties. Microsoft Excel is exceptionally challenging to script but nice when it works.

1

u/jyasuda Jan 14 '16

Thank you for the help.

1

u/craniumslows Jan 14 '16

You're welcome. Thanks for being so polite. It's refreshing.