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
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |