vishwamitra

About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

How to Edit Existing Conditional Formatting

For editing Conditional Formatting of an Excel Workbook, follow following steps. It is different for Excel 2003 and 2007. So we will see the steps for both Excel 2003 and 2007. Excel 2007 || Excel 2003 […]

Conditional Formatting in Excel

Conditional Formatting in Excel: In MS Excel we can do formatting of cells based on some conditions or values. This is called Conditional formatting. For example, if you want a cell color to be red whenever the Value in the Cell is updated as “FAILED” or “Less Than 60%” etc. then we can apply conditional formatting in that cell. Conditional formatting can be done on a single cell or a range of cells or […]

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")

Sorting a String stored in a cell of Excel

Dear Readers, By using Excel Macro, we can sort a String which is stored in a Cell in an Excel Sheet. Sorting will be done as a String. For example (Ascending): First all Numeric Values in ascending Order then Special Chars then Alphabets in ascending etc. Sorting For this we need to copy and Paste below Sub Function [...]

List All files from Folder and Sub-folders in Excel Workbook

By using File System Object, we can get list of all Files inside a folder. There can be two types of requirements here. Either user wants all files in only one Folder or list of all files in All folders and its sub-folders. Following is the solution for both the requirement: User wants to get the list of All files [...]

GTIN Calculator in Excel

GTIN Calculation is basically of different types like GTIN 8, GTIN 12, GTIN 13 and GTIN 14. We can calculate GTIN by using Excel Formula as well as Excel Macro. GTIN Calculator By Formula | GTIN Calculator By Macro | How to Calculate GTIN | Download GTIN Calculator GTIN Calculation- By Excel Formula: GTIN-8 "000000"&F11 & (IF(MOD(3*(MID(F11,1,1) + MID(F11,3,1) + [...]

By |Categories: Excel Macro, Popular Articles|Tags: |11 Comments

Oracle Connection String in VBA

Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I will teach you, how you can do a connection with a Oracle Server. We can do connection with Oracle either by giving SID (Oracle System ID) or Service Name. Whichever is available for the connection, we can use them [...]

Restrict to fixed text or integer length in the given range of cells

Follow below steps to Restrict to fixed text or integer length in the given range of cells: 1. Select the Cell Range where you want to put the restriction 2. Go to "Data" Tab in Excel   3. Click on Data Validation Option and Select "Text Length" from the Drop down as show below:   3. Select the Data option [...]

Filter by Cell Color in Excel

In Excel 2007/2010, it is very easy to filter rows by Cell Color. In Excel 2007/2010 we have inbuilt functionality to do so. There can be two way to do this Filter by Color. Follow the below Steps to Filter by Cell Color in Excel 2007/2010: 1. Select the Range where you want to apply the Filter. […]