Excel 2010 VBA Tutorial 41 - Events - Workbook Before Save

How to run VBA code before the spreadsheet is saved.

[jadjouds]

Excellent Tutorials, eagerly waiting for the userform tutorials

[fenghuayang]

Hi, Sir, Thanks for your tutorials. It helps me a lot.

But, could you update the tutorial series? I am waiting for the new tutorials released.

Thanks.

[Maartenmarsje]

Thanks for all your great tutorials Malfunction9, I've watched them all multiple times. I have a question for you. I am trying to use this code in my own files with the & ".xlsm", but I still get a the following message from Excel:

"The following Features cannot be saved in a macro-free workbooks:

VB Project

To save a file with these features, click no, and then choose a macro-enabled file type...."

Do you have a solution for this problem?

Gr. Maarten

[YourprogrammingnetworkCoUk]

Could you possibly post this question in our new forum? (Link above) would be much appreciated.

Which version of excel are you using? It will be different depending on which one?

[surajrajrana]

Hey Matt, First of all Thank you very much for these tutorials. But i have problem regarding saving macro, after completing the macro program, when i came out of excel and restart that excel again, i am not able to see an program in Excel, Please suggest.

[mrli]

Hi
thanks for this tutorials , I want to ask you, , How insert external file path in vba ? and I want path file in same folder, Because the path maybe change .
like c: or d: or f:

[gdorman]

Is it possible to apply the first example macro to multiple/all files in a folder? Also would like to apply this code to a macro that I already have looping through files and doing certain tasks. Thanks!

[milanpanchal]

Thank you for the tutorials. I have a query, I can not save my file with .xlsm behind. I have written the same as you told, but still it is not working. what could be the problem ?