Can I run applescripts from within Excel

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

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

Thanks buddy.

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

Thank you