I had a need for processing data that came in .DIF files, so I put this UDF together to handle the files.
Hopefully, it will be of value to others here in the forums.
DifHandler reads data from a .DIF file to an array, or writes data from an array to a .DIF file.
I have also added support for the Microsoft mistake, and can read .DIF files generated by Excel.
You can download it from here: https://www.dropbox.com/s/4z8m7kgqw7oi7e9/DifHandler.zip
Please let me know if there are any problems or improvements.
----------
I have been finding that lots of applications do not adhere to the specs very well, so ...
Here is version 2, written to be a little more forgiving. It will still set the appropriate @error value, but will still attempt to read the full DIF file, and return it in the array.
https://www.dropbox.com/s/ld3s32kr621lms9/DifHandler_v2.zip