Private Declare Function fread Lib "libc.dylib" (ByVal outStr As String, ByVal size As Long, ByVal items As Long, ByVal stream As Long) As Long Private Declare Function pclose Lib "libc.dylib" (ByVal file As Long) As Long Private Declare Function popen Lib "libc.dylib" (ByVal command As String, ByVal mode As String) As Long Using the system() command isn't an option as the output is needed for the VBA script.
The other solution would be to use the MacScript command, but this shell script contains regex with "\" and multiple quotes, and it's very difficult to translate to applescript, so my preference is to use this method as it already works.
At the beginning of the run, I can see the sheets being updated and everything running smoothly, but later in the script excel freezes until it completes. Ideally I'd like to have feedback on the status of the script, which I tried to implement with a status bar, but this didn't work because of a limitation with 2011 version of Excel. I thought that the function calls would be processed linearly, but I'm thinking that maybe it could be concurrently processing the shell scripts, and this could be causing the problem. Maybe after a few consecutive failures terminate the script completely. If there's a lengthy delay with a curl request, I'd prefer to abort it and continue with the script. If it ran smoothly it wouldn't be a problem, but at times it can seem to lock up completely. "curl -connect-timeout 5 -max-time 10 -retry 2 -retry-delay 0 -retry-max-time 40 ", and also added 0.1 second delay before each call. I'm wondering if it's possible to abort or timeout the function if it's taking a long time to execute? Is there a method that could be used to handle multiple function calls? I've added timeout to the curl command in the shell script. I'm guessing that this part is executing within the shell and popen is initialising, but I don't really understand what it's doing.
Within the function is a while loop, and it runs much slower than the popen. VBA Shell function in Office 2011 for Mac I've been using the function from the top answer to this question to run shell scripts within VBA (the execShell function), which uses libc.dylib:
0 kommentar(er)
