Question or issue on macOS: Hi I am trying to list all the files in a subdirectory of where the Excel workbook is residing in. For some reason, the code cannot execute beyond the Dir function. Can anyone please advise? Thank you!
Continue Reading
Question or issue on macOS: I have developed an Excel 2010 VBA Macro that makes use of VBScript.RegExp. One of my users is apparently using Excel Mac 2011, which supports VBA, but no VBScript.RegExp.
Continue Reading
Question or issue on macOS: How can I run a bash file using VBA on MAC OSX
Continue Reading
Question or problem about Python programming: I know there is a ton of these threads but all of them are for very simple cases like 3×3 matrices and things of that sort and the solutions do not even begin to apply to my situation. So I’m trying to graph G versus l1 (that’s not an […]
Continue Reading
Question or issue on macOS: I need to issue an HTTP Get with a query string to a web service from Excel for Mac 2011. I’ve seen the answers for using QueryTables (How can I send an HTTP POST request to a server from Excel using VBA?) but they use the POST method, not a […]
Continue Reading
Question or problem about Python programming: I am trying to read a .xlsx with pandas, but get the follwing error:
Continue Reading
Question or issue on macOS: I am trying to launch a shell script from a VBA macro in Word 2011 for Mac that will run in a Terminal window. I have tried using both the Shell function and the MacScript function, but the VBA interpreter doesn’t seem to be able to find the script in […]
Continue Reading
Question or issue on macOS: I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects. I recently had a user attempt to use it on a Mac and received the following error:
Continue Reading
Question or issue on macOS: I need to call LINEST in Excel 2011 for Mac, I would say – this was a detective story. My laziness, my curiosity, all was here! I had a homework from university course to use LINEST.
Continue Reading
Question or issue on macOS: This is a common issue I have and my solution is a bit brash. So I’m looking for a quick fix and explanation of the problem.
Continue Reading