this post was submitted on 28 Jan 2024
2 points (75.0% liked)

macOS

941 readers
1 users here now

The home for all things macOS on LW.

Rules:

founded 1 year ago
MODERATORS
2
submitted 9 months ago* (last edited 9 months ago) by RestrictedAccount to c/macos
 

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.