Questions tagged [applescript-excel]
3 questions
0
votes
0 answers
Using Applescript to open an excel file and enable macros in MacOs
How can I use Applescript to open an Excel file in MacOs and enable the macros?
I have tried :
-- Set the path to your Excel file
set excelFile to "/Users/spagcoder/Desktop/proms webform/PROMS.xlsm"
-- Launch Excel in the background
tell…
SpagCoder
- 1
- 1
0
votes
0 answers
Using Applescript to run an Excel macro
I want to schedule an Excel macro to run every week on MacOS. I am using Applescript but when I run the script, it seems to open the file but the macro doesn't run. Also, how do I automatically enable macros when the Excel file is opened?
This is…
SpagCoder
- 1
- 1
0
votes
0 answers
How to use "AXSubrole", "AXRoleDescription" in applescript?
Can we use "AXSubrole", "AXRoleDescription" in applescript? If yes, what is the correct way? I tried following code.
-- open Excel -> VB Editor
tell application "System Events"
tell process "Microsoft Excel"
tell window 1
if…
Am33t
- 13
- 3