macOS

950 readers

5 users here now

The home for all things macOS on LW.

Rules:

No NSFW Content.
No hate speech or personal attacks.
No Ads / Spamming.

founded 1 year ago

MODERATORS

kylewritescode

Help! Trying to Shell Out of Excel (self.macos)

submitted 9 months ago* (last edited 9 months ago) by RestrictedAccount to c/macos

2 comments fedilink hide all child comments

I am trying to shell out of VBA in excel and I keep getting permissions issues. So far I have tried:

Full Disk Access

Accessibility

Developer Rights

chmod

Quarantine

Shell function

AppleScriptTask function (with full disks access and Accessiblity, and Developer Rights)

All of the pieces work independently. I can call it from the command line and as an apple script from osascript

The MOST frustrating thing its that once I got the permissions correct on Apple Script, then the excel AppleScriptTask function stopped working. The command that used to work now throws an Error 13 Type Mismatch. I have double checked, triple checked and had Chat GPT write the code. There is not type mismatch - and it worked fine before I fixed the permissions on Apple Script.

PLEASE HELP!!!!!!!!

top 2 comments

sorted by: hot top controversial new old

[–] [email protected] 2 points 9 months ago (1 children)

Do you happen to work at a large company that runs their whole business via Excel?

[–] RestrictedAccount 1 points 9 months ago

No, just my personal machine.