Run Python Script from Excel VBA - Part 2

In this video we will send parameters and read a response from a python script using VBA.

Support this channel, become a member:

🔥 Udemy Courses LOW COST Coupons/ Cupões Cursos Udemy BAIXO CUSTO 🔥:

With Udemy Courses you get/ Com Cursos da Udemy você terá:
♾️ Full lifetime access/ Acesso Vitalício Completo
📱📺 Access on mobile and TV/ Acesso no celular e TV
🏆 Certificate of completion/ Certificado de Conclusão

📚 Useful books from Mike Driscoll 📚:

◾ 💸 Donations 💸 ◾
Please consider giving a donation so I can improve the quality of this content that I made for all of you 😊

Other videos

Playlists:

Follow me on Facebook

Or Twitter

#Excel #VBA #Python #tutorial #howto #AllTech

[AllTechPage]

🎅 Christmas Udemy Cupons 🎅 Ends in 1 day! 89% OFF!



🎅 Cupons de Natal 🎅 Termina em 1 dia! 89% de desconto!

[DirkSiebert-vc]

Thanks! I saw many other tutorials which do not work. They typically already fail (which is not a functional bug, but ...) in the first line (which is your 2nd line in chapter 2 ) when they define more than one variable in a single line.

[MattiaConti]

Very like how you edit the video in order to better explain things!

[nithinrajmohanraj]

Thanks for the clear explanation.
Do you have a video that explains how to send large amount of data from script to excel?

[raphaellamarche]

hey, thx for the video,
@AllTech
would you have a idea for which the atendofstream would return a true even if the python file print an output, if i past the command from the code int the command prompt it work

[influencedbyprabhkirat]

I have a variable in Python named y_pred and I want to output its value in excel, how can this be done?

I am using the earlier formula for the same - objShell.Run PythonExe & PythonScript

[KhalilYasser]

Amazing. Thanks a lot for this tutorial.

[neto]

This is really nice video! thx. If i have ha in A1 Full Names, the code just return Full...the space between words seems a problem. Can u help?

[victorcaricatti]

hey bro, i like your videos. Congrats!

[clearthinking]

Hello, very clear explanation; would you agree that it is always better to import/analyse data using python and then simply export the final result into excel? I am contemplating learning VBA but it seems like a waste of time given you can do everything in python. What do you think?

[brunaamancio]

Hey, @AllTech. How can I get the python return value using shell.run instead of exec command? Is it possible? Thanks.