How To Execute An Excel VBA Macro From Python

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This video will show how to execute an Excel VBA macro from Python using the xlwings library.

✅ 𝗦𝗢𝗨𝗥𝗖𝗘 𝗖𝗢𝗗𝗘:
import xlwings as xw

# -- OPEN WORKBOOK

# --- EXAMPLE 1
macro1()

# --- EXAMPLE 2
macro2("Ahoy")

# --- SAVE & CLOSE WORKBOOK
else:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

*I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.*

[Rezzznr]

thank you so much for proper closing instruction! I've been fighting with this for several hours...

[rajeshsn]

Hi, Thank you for sharing this. I been searching for this solution for a while now. You are the best.❤❤

[KhalilYasser]

Amazing. Thanks a lot for all these great tutorials.

[dragosborosgpt]

very cool. as an improvement you can add after, the import command, the following python code "app = xw.App(visible=False)" This will run Excel in the background and will not obscure your PYTHON workflow with flickering Excel tasks

[KeyserTheRedBeard]

nice video Coding Is Fun. I crushed that thumbs up on your video. Keep up the really good work.

[MegaGrac]

you're the best
Great thx to you from France

[praldemir]

Very very beatiful!! You're helping me a lot! I'm from Brazil and studying Python into Knime. I have many macros and do this it will help me. Do you have videos about Python with knime?

[taarigo]

Thank you, awesome video. I tried with my own vba macro, but I have a run time error '1004' reference isn't valid my which point a goalseek used in my macro. Please can use goalseek function in a macro and run macro from python just like your video?

[mtggamer]

Really nice content, thank you for your work. My question to you is: How can we inject a vba file into any xlsm file?

[magnetriceric]

Hi Thanks for your sharing. However, how to run a macro code for another excel file. For example, I created empty excel by xlwings and then fill in some values in it. Now I wanna implement a macro code for that created excel file. How should I do?

[suveeshmalachiyil]

Hi, could you also help us to close vba message box using python script in the end when the macro is completed running.

[calebhildbold]

Is there a way to run a macro that requires the user to select an .mdb file during the process?

[sebastianrubiocastillo]

Is there a way to run a macro saved in PERSONAL wb into any excel file?

[iamtoqeerzafar]

Great information... can we also convert this python code to .exe (using pyinstaller)? We have a webscrapper macro, if we run it from python and then convert that python script to .exe will it work or the whole vba code should be replaced by python script in this case?

[CM-nilb]

Does this mean Python actually waits for the instance to finish the execution before going to the next step like saving the workbook? Sorry, I just have this issue with batch files.

[AvinashKumar-xjdp]

Hi Sven,
Can i run the Excel Macros through Python by not opening excel itself?

[taarigo]

Hi
Thank you again for this video, I tried your method on linux server, but I have this message:
xlwingsXlwings Error: Your platform only supports the instantiation via xw.Book(json)
What does this mean?

[mesteban]

excellent man!! Is there a way to click on the macro message with some code? thanks!!

[deeshusvlog]

What of we need to run multiple macros with the same code