Forum Discussion
oatmeal123
Jan 10, 2023Copper Contributor
Automate creating .scpt file in application scripts folder on Excel VBA for Mac OS
Hello! I wanted to see if there was a way to use VBA to automate creating a .scpt file in the application scripts folder ("/Users/ComputerName/Library/Application Scripts/com.microsoft.Excel") on Ma...
oatmeal123
Jan 12, 2023Copper Contributor
peiyezhuI'm using a .scpt file to run shell commands. On Excel 2016 and above for Mac, I have only found one way to run a shell command, which is through using Excel's applescript function. Using the applescript function requires a .scpt or .applescript file in the application scripts folder. Are there other ways to run a shell command on Excel 2016 and above for Mac?
peiyezhu
Jan 12, 2023Bronze Contributor
Is there any way to create files in that folder without the user having to do anything?
how about php or bash on Mac to create a .scpt file rather than vba which may repoert grant permission.
how about php or bash on Mac to create a .scpt file rather than vba which may repoert grant permission.
- oatmeal123Jan 13, 2023Copper ContributorMy Excel spreadsheet is being used like an self contained app, so I want to use VBA to run all the necessary things.
- peiyezhuJan 13, 2023Bronze Contributor
try change folder access rights
e.g.
/Library/WebServer/Documents
is your path.
sudo chmod -R 0777 /Library/WebServer/Documents
https://blog.csdn.net/qq_39997939/article/details/122893354
https://www.cnblogs.com/phpyangbo/p/15538981.html
https://blog.csdn.net/weixin_42274846/article/details/128034612