Actions performed on an Excel sheet can be automatically recorded as a VBA (Visual Basic for Applications) script. VBA is a programming language used in Microsoft Office applications, including Excel, to automate tasks and perform actions within the application.
Steps to import VBA script file in Excel sheet :
1. Open the Excel sheet in which you want to perform actions. Go to Developer tab. If its not enabled, follow the steps mentioned in below article.
How to enable Developer tab in MS-Excel?
2. Under Developer tab go to Visual Basic or press Alt + F11.
3. Select the required .bas file and click open.
4. The .bas file gets imported to Modules folder under VBA Project.
5. Now open the .bas file present in Modules folder and click on run button to get the required output.
