GEARZ.de

All snippets are without any warranty.
Alle Snippets sind ohne jegliche Gewähr oder Garantie.



VBA-Funktionen:

xls import
v0.5
VBA-Code to import a large ASCII-file. Every 30.000 lines a new sheet will be created. Small GUI and Dialog-windows.
walk through a given folderVBA-Code to let Excel walk through all files in a given directory.
Test for folderVBA-Code (Excel) to test the existence of a given folder. If the folder doesnt exist, the function tries to create the folder and checks for success. Returns True or False.
Get Last Column / Last RowVBA-Snippet (Excel) to get the last row / column