Taupirho,
thanks for the reply. I'll try to answer. However I think the problem is in the csv, which was added to my first post. Would you mind trying the code with that csv-file?
My actions in the meantime were:
My collegae changed the outpu-file to comma-seperated. I changed the code...
Taupirho,
thanks for your reply.
The csv-file uses ; as delimiter. First we were using TAB as delimiter. It gave the same problem. We've changed to ;, but it didn't make any difference.
Should we swap to ',' anyway? Is that causing the problem?
Thanks
Rinze
Hi all,
I've used several tips to read a csv-file. However I can't seem to get it to work.
I use the next code:
====================================
Dim fs, objTextfile
Set fs = CreateObject("Scripting.FileSystemObject")
dim arrStr
set objTextfile =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.