Wednesday, March 15, 2017

How to save workbook

Sub Save_WorkBook()
   
                ActiveWorkbook.Save

End Sub

_______________________________________________________________________

Sub Save_WorkBook()

                ActiveWorkbook.SaveAs Environ("Userprofile") & "\desktop\test.xlsm"

End Sub

No comments:

Post a Comment

*INTERVIEW QUESTIONS

* Ques 01. What is the difference between ByVal and ByRef and which is default ? Ans-  ByRef : If you pass an argument by reference when...