Popular Articles

This is the category all the popular articles are categorized. Interested in reading all the popular reads.. this this the place

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 [...]

How to restrict some key or Characters in text box in a Excel Macro

When you are using Text Boxes in Excel Macros then there are some instances where you want to restrict some entries in the Text Box. For example: A Textbox where you are entering Amount. Here you may need that you should be able to Enter All numeric characters from 0-9 and also Decimal (.) and Minus Sign(-). You don’t have any inbuilt functionality in Excel Textbox to restrict it to only Numeric Value. However by writing a piece of Code under KeyPress Event of Textbox, you can achieve this. Just copy paste the below mentioned code under KeyPress Event of the Text Box. […]