I am attempting to pull data from a .csv to an Excel file. I figured a good way to do this is to use QueryTables. Nonetheless, I have some questions about doing this:
1) Is using a QueryTable to pull .csv data the best way? (Stability then speed are the most important to me.)
2) What is the best QueryTable settings that will work no matter what version of Windows someone is using. (i.e., Windows 7, Windows8, Windows 10, 64 bit or 32 bit.)
The reason I ask is there are different opinions on what to use for the .textfileplatform property on a query table and I still don't understand exactly what it does. Some people say use textfileplatform = 850, while others say use textfileplatform=437. In all reality, I would just like some solid code that will import .csv data no matter what someones Windows setup is.
A sample link of QueryTable code is here: https://msdn.microsoft.com/en-us/library/bb221760(v=office.12).aspx