Sat 12 Aug 2017

Downloads 16 - Sample CSV Files / Data Sets for Testing - Human Resources

By |Saturday, August 12th, 2017|Categories: Downloads, VBA|Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , |0 Comments

Disclaimer - The datasets are generated through random logic in VBA. These are not real human resource data and should not be used for any other purpose other than testing.

You can download sample csv files ranging from 100 records to 500000 records. These csv files contain data in various formats like Text, Numbers, Date, Time, Percentages which should satisfy your need for testing.

This data set can be categorized under "Human Resources" category.

Below are the fields which appear as part of these csv files as first line.

(more…)

Sat 14 Feb 2015

Article 11 - How to Encrypt Excel Workbook

By |Saturday, February 14th, 2015|Categories: Articles|Tags: , , , , , , , , |0 Comments

Note - The article is for Excel 2010 / 2013 versions and doesn't cover any version prior to Excel 2010.

Excel 2010 / 2013 uses default 128 bit AES encryption which is considered highly secured. If you are interested in knowing all things about Excel security, I will recommend following MS article -

http://technet.microsoft.com/en-us/library/dn194021%28v=office.15%29.aspx

---- Update on 27-Jun-15 - Following is a very good article which contains some useful info on Excel security -

http://www.thespreadsheetguru.com/blog/2014/8/20/understanding-excels-password-security-methodology ----

Anyway, coming back to topic, there are 4 ways to encrypt Excel Workbook (Not counting VBA to do this which is not a safe way to encrypt).

1. Way 1 - Encrypt Document Button - This is recommended if you encrypt your workbook very often. (more…)