Automate Spreadsheet Transformations

Question

Hello,

Every month I process a vendor's MS Excel spreadsheet for my work. I have to remove columns, rename columns, re-format columns, and then email the resulting spreadsheet to colleagues.

Is there a way, in Excel or Numbers or programmatically, to automate this extremely repetitive process?

Thanks, Sergio

Answer 1

Excel for Mac supports Applescript so you could script the process. RealBasic can automate Excel. Excel for Mac used (5+ years ago) to ship with a reduced version of it. Don't know if it still does.

Applescript support in iWork Numbers is rather good so if you have Numbers I would suggest importing into Numbers and running the script there.

Answer 2

You probably want to post this question on http://superuser.com/questions/tagged/excel Excel has built in support for macros.