Interesting VBA Functions

Input Box and “Smart” Input Box

The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New WorkSheet in a Workbook but the Sheet Name you want to [...]

Get Special Folder Path using VBA

Hello Friends, In this article I am going to explain you how to get the path of Special Folders in Windows Operating System. Using VBA we can get path of Special folders path like, Desktop, My Documents, Library etc. Few important special folders are listed below. There are many more special folders available but I am putting code for only [...]

Download Free File Manager – New Version

Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel. Based on some valuable inputs and queries, [...]

VBA: Reverse a string

It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse() is the inbuilt function which returns reverse of the String given as input to this function. Syntax: strReverse("Your Input String") Returned Value: It returns a reversed string of your given input String. Example:Below code will return the [...]

How to run a .bat file (Batch File) by Excel Macro

By executing the below code, you can run any .bat file in Excel Macro. This is very important that you should keep your Excel Sheet from which you want to execute the Batch file in "C:\" drive only. It can be inside any other sub-folder but in C drive Only. shell("c:\abc.bat") ' OR shell("CMD.EXE /c c:\abc.bat")