I know you asked for a non VBA way, but for completeness I’m adding another answer that also has a VBA solution, because it’s dead simple, it’s blazingly fast, and it’s generic. All you need to do is cut and paste this code into a standard code module, add a button and assign it to … Read more
Open the CSV file with a decent text editor like Notepad++ and add the following text in the first line: sep=, Now open it with excel again. This will set the separator as a comma, or you can change it to whatever you need.
Ups, I entirely forgot this question. In the meantime I got a solution. This Powershell script converts a CSV to XLSX in the background Gimmicks are Preserves all CSV values as plain text like =B1+B2 or 0000001. You don’t see #Name or anything like that. No autoformating is done. Automatically chooses the right delimiter (comma … Read more
PIAs are a historical artifact, required only by old .NET versions (before v4). They have been thoroughly and elegantly replaced by the “Embed Interop Types” feature, also known as the “No PIA” feature. Supported since Visual Studio 2010, you’ll find it back in the Properties window when you select a reference assembly. It defaults to … Read more