Run Macro When You Open/Close a Workbook (Excel File) - Excel VBA

In this video, you will learn to write a macro that can be run while opening or closing a workbook (Excel File). In VBA, there's a statement called auto_open and auto_close that you can use for this. So make sure watch this video till the end.

---------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------

#ExcelTips #LearnExcel #ExcelTutorial #Excel

[pakalupapito]

thanks for sharing this amazing tip on VBA.

[gustavopineda]

Wow!! Useful video, thanks bro I started to follow you and now I'm happy to found this channel.

[TheYear-dmop]

Wow, thank you! I knew about the workbook_open sub. The name generates automatically when you choose certain things above the code view. But there are no options to choose "workbook" and "close". Wich is weird, because obviously the funtionality to run a macro on close exists.

[cayogendradhaka]

is it possible, when we open an excel file and some combobox button auto work with add item

[knowledgewithhasu]

Sir, ek video banaiye Tax invoice me quantity and rate jo 12 % tax lag raha hai (above 1000 rate) to convert kare ke quantity and rate 5% me (under 1000 rate) quantity increase kar ke per taxable value same karke excel me format kese banaiye

[jhamca]

Thanks for sharing this, Puneet can you respond on this, I have three word document and in all three documents same column like name, rollnumber, marks and in all three document data it is there I want to merge the data in one documents from all three documents with same header

[NaveenKumar-srff]

Good evening, 5 min, 15 min, 30, min, 1 hr- me at a time VBA recording kaise kare, video baneye plz

[sachindaga]

I deeply sorry to see that you put a lot of effort to connect with people with your knowledgeable content but still very few views. 😌😌😌😌