Tag Archives: File handling

Querying Text/CSV files. Method #1: Querytable

Posted on Jan 13, 2021 by Patrick O'Beirne, Excel/VBA developer

The legacy Get Data from Text/CSV command in Excel creates a Querytable. This is pretty good for most purposes, except… Continue reading →

Posted in Excel/VBA | Tagged , , | Leave a comment

Reading Unicode file contents as text

Posted on Jan 12, 2021 by Patrick O'Beirne, Excel/VBA developer

This is a short update on my post of Sep 28, 2020 on reading Unicode text in VBA. I am reposting the module as ADOStream.bas Continue reading →

Posted in Excel/VBA | Tagged | Leave a comment

Hello (the rest of the) World – reading data in other languages

Posted on Jan 11, 2021 by Patrick O'Beirne, Excel/VBA developer

Have you ever opened a text file in Excel and found that the characters looked weird or corrupted? The Wikipedia entry for mojibake says ‘In German, Buchstabensalat (“letter salad”) is a common term for this phenomenon, and in Spanish, deformación … Continue reading →

Posted in Excel/VBA | Tagged , , , | Leave a comment