Tag: vba

These are our Top 10 reads of July 2015. How to match strings using wildcards in C# and VB.NET IsSmallerThan generic extension method for C# and VB.NET How to prevent…

To show and select a file in explorer using VBA you can use the following snippet. This snippet should also work in VB6. Sample VBA

To open a file or folder using VBA you can sue the follwing snippet. This snippet should also work in VB6. Sample VBA

To make a multicolumn listbox in VBA you can use the following snippet. This snippet should also work in VB6. Sample VBA

To create and write a textfile in VBA you can use the following snippet. This should also work when using VB6. Sample VBA

To split a string into collection in VBA you can use the following snippet. Sample VBA

To sort a collection in VBA you can use the following snippet. This snippet is using bubblesort. Sample VBA for more informations see Bubble sort

to get the temp folder in VBA you can use the following snippet. Sample VBA

To read a textfile line by line in VBA you can use the following snippet. To read a textfile complete into a string you can use How to read a…