Can I run applescripts from within Excel

Scripting Forums AppleScript | Mac OS X
,
#1

Hi

I have an applescript that works out some values (not important) and copies them into my clipboard. I then open an excel spreadsheet and paste those values into specific cells that are then used elsewhere in the spreadsheet.

My question is this… Is there a way of running this applescript from within my spreadsheet (via a push button or shortcut). I know that macros are a thing in excel but can a macro be used to trigger an applescript? if so how?

This should make the process easier and more user friendly.

Thanks

Tim

#2

Assuming you’re using Excel 2016 or later, use AppleScriptTask() to run an AppleScript within Excel.

https://docs.microsoft.com/en-us/office/vba/office-mac/applescripttask

#3

Thanks buddy.

I did see that, but didn’t understand it at first. I’ll have another crack!

Thank you