It took me a few hours to seach how to retrieve list seperator from VB.NET. There are lot of example but most of them using Win32 API. Just in case it not support in 64 bits os, I decided to look into dot net framework. Finally, I found it !
There are two ways to get the value of List Seperator:
1. Application.CurrentCulture.TextInfo.ListSeparator
2. System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator
Why list seperator? When Microsoft Excel save a comma seperator value (.csv) file, it actually follow the list seperator value in regional setting. We always thought the csv file using comma but it can be customize in regional setting. For, application to read csv file need to take extra care on what the list seperator value.
Happy Coding....
