Sunday, September 22, 2019

#1 2019-04-17 05:40:33 am

timbaldwin
Member
Registered: 2006-08-14
Posts: 71

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


Filed under: excel

Offline

 

#2 2019-04-17 12:39:57 pm

billearl
Member
Registered: 2003-02-26
Posts: 34

Re: Can I run applescripts from within Excel

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

https://docs.microsoft.com/en-us/office … scripttask

Offline

 

#3 2019-04-23 07:08:34 am

timbaldwin
Member
Registered: 2006-08-14
Posts: 71

Re: Can I run applescripts from within Excel

Thanks buddy.

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

Thank you

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)