Excel VBA - Save & Close Workbook

Excel VBA - Save & Close Workbook
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[mukeshbhatt]

i think very simple and concise delivery of VBA coding available on the net thusfar....Congo !

[creativeideas]

I LIKED IT 😎😎IT IS GOOD IAM WATCHING ALL YOUR VIDEOS

[stocktrader]

Excellent information and way of teaching.

[akrishnan]

Avoid .xlsx in inside the Workbook bracket . type only Book4" = "Chennai"

[surrealismo]

Hi, thanks for the info.
Just want to know if its possible to close the file after a period of time. My macro refresh some odata connections, so the file need to refresh connections, copy some info, save and the close. If i try to close the file not refresh the odata connection

[rahulkhosla]

Is there any session on how to save a file based on cell value?

[rangavijay]

thanks, but the code says Sheets1 and excel has sheet1 if you see, its actually thrwing me error 9

[jazyhappy]

I want to stop macro to create seprate file... It should update data in same file.. how to do that

[ayushm]

i have one requirement to save my workbook by every 1 second. i have written this code in module
Sub SaveIt()

ThisWorkbook.Save

Application.OnTime Now + TimeSerial(0, 0, 1), "SaveIt"

End Sub

it is saving, but after some time it is piping up other excel sheetto save .
plz tell me how to avoid that

[baluchethanh]

Hi, am trying to protect active workbook close event from macro which is in personal.xlsb am unable to do that when multiple workbooks are active, can you help me out!

[thidaratchanel]

if i want to save A2 :D20 in open workbook to cloesd workbook
How i code?

[lschan]

it is saving, the workbook is close but I still have to click on the "X" to close excel?

[aprilsyrangomez]

goodevening . Namaste .please have a video on hide hyperlink sheets . when the sheets are hide the hyperlink is not working please help me.

[humtraderhai]

As soon as Workbooks("Book1").Save gets executed workbook closes and gets saved at default location in C:\Documents

Edit : It seems Book1 was created at the location E: first and then rest of the video follows.

[md.moniruddin]

What would be the code if I want to save the work book which have multiple sheets and whole area is the range.

[romanov]

Hi, Thank you for providing such good knowledge. when there are two different files are open at the same time and when working on the file which has no macro and if the micro is scheduled run at the particular file which is open but is in a minimize mode then the error 9 occurs. Please help to fix this error 9

[sirajbhaiparmar]

how can automatic save excel file as encrypt pdf using VBA ? plz reply

[kathireshkavi]

I have a
Here we didn't mention save location.. then how it stored in E drive

[ErJanardhanJethi]

Hi, I'm opening an existing Excel file n editing in vb6.0 then saving it. But not able to close the Excel n I can see the excel.exe in task bar.
How to close from task bar ??