Category: VBA

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 read a textfile in VBA you can use the following snippet. to read a textfile line by line see How to read a textfile line by line in 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…