In this tutorial we will guide you on how to save files in Excel using VBA. Visual Basic for applications (VBA) is a powerful programming language designed and developed by Microsoft. It is integrated in many Microsoft Office applications like Excel, Access etc. to helps users to create their own functions to perform specific tasks. Here we are showing you how a “Save as” option works by using Excel VBA. Instead of using the “Save as” button, we will record a macro and use the double click option in VBA Excel for save as function.