AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excel button for macro mac5/4/2023 ![]() ![]() ![]() ![]() ("A1").value = "Hello World"Īccording to the docs and researching responses, Mac can't even use ActiveX. This error does not occur on all computers.Īnd here's the Python code (not super mind-blowing I know): import xlwings as xw This error occurs when the Component Object Model (COM) cannot create the requested Automation object, and the Automation object is, therefore, unavailable to Visual Basic. The line the VBA debugger says is wrong is: Set objShell = CreateObject("Wscript.Shell")īased on the error message: RUNTIME ERROR ' 429'. When I run the macro, I get the following error: Run-time error '429': ActiveX component can't create object ObjShell.Run PythonExePath & PythonScriptPath PythonScriptPath = "/Users/XXXXXX/Desktop/test/test.xlm" PythonExePath = """/Library/Frameworks/amework/Versions/3.8/bin/python3""" Set objShell = CreateObject("Wscript.Shell") Here's the VBA code: Sub RunPythonScript()ĭim PythonExePath, PythonScriptPath As String I'm using XLWings, Catalina 10.15 and the Developer Tab in Excel for Mac 16.4, if that helps. just trying to get this thing to work and have spent weeks searching for answers with no luck. Trying to launch a python shell script from a macro button in one excel file (test.xlsm) that executes in another file (hello.xlsx) in the same directory. ![]()
0 Comments
Read More
Leave a Reply. |