KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have Python code that reads three arguments (scalars) and a text file, and then it returns me a vector of double. I want to write a macro in VBA to call this Python code and write the results in one of the same Excel sheets. I wanted to know what was the easiest way to do it. Here is some stuff that I found: call the shell() function in VBA, but it doesn't seem so easy to get the return value. register the Python code as a COM object and call it from VBA. I don't know how to do that, so if you have some examples it would be more than welcome create a custom tool in a custom toolbox. In VBA, create a geoprocessing object and then addtoolbox. And then we can use the custom tool directly via the geoprocessing object, but this is something as well that I don't know how to do.. Any tips?
Tags (comma-separated)
Save Edits
Cancel