Thursday, April 28, 2016
Get FileName list form a Folder in EXCEL
›
The code below retrieves the file in this directory and creates a list of their names and paths: Sub GetFileNameList() Dim objFSO As Ob...
Friday, April 8, 2016
Get alternating row colors, using conditional formatting in Excel
›
I got a questing about how to set alternative color in excel sheet when not using table. Steps: 1) Select the rows you want alternate co...
Wednesday, April 6, 2016
How to Test a Database Connection String using NotePad
›
Create and Configure a Universal Data Link (.udl) File with Notepad. I just came across a way to test a data provider’s connection str...
Wednesday, March 16, 2016
'Positives in Negatives'
›
A young woman was sitting at her dining table, worried about taxes to be paid, house-work to be done and to top it all, her extended ...
Thursday, March 10, 2016
Count the number of spaces of text string in Excel
›
Simple to calculate the number of spaces of text string in EXCEL with following formula: =LEN(A1) - LEN(Substiture(A1," ",&quo...
Wednesday, March 2, 2016
10 Steps to Dealing With The Negative People in Your Life
›
Following contents were received in one of my email from friends, all credits goes to the person who wrote wonderful thing. Read the steps...
1 comment:
Tuesday, March 1, 2016
Turn Off Autorun or Autoplay on Windows system
›
Mostly Virus easily spreading using removable media such as CD, USB, etc. Some people maybe still didn't know how to turn off autorun...
‹
›
Home
View web version