Load data from text file - needed fileds in VB

[luv2glyd]

Trying to simply import the contents of a csv file that is 64 rows by 7 columns and wanted to save some room in the editor. Below is what the macro recorder recorded and then I tweaked a 2nd and 3rd rows a bit. Can I simply delete the commands with " = False" next to them? Also, what does ".TextFilePlatform = 437" do?

Please Login or Register  to view this content.

Thanks

[LJMetzger]

Hi,

.TextFilePlatform determines the Source of the Data (Windows=2, MS-DOS=3, Macintosh=1)
See https://msdn.microsoft.com/en-us/lib.../ff196091.aspx

Other numbers are apparently IBM-PC = 437, and Unicode=65000 which are 'Unicode Code Page Identifiers'.
See https://msdn.microsoft.com/en-us/lib...=vs.85%29.aspx

And for more than you will ever want to know there is Wikipedia:
https://en.wikipedia.org/wiki/Code_page

I too am of the minimalist school. However, the days of saving bits and bytes are long gone, when I had to fit ten pounds of code into a five pound bag of ram. I gave up preening unnecessary Macro Recorder generated code a long time ago, unless I was positive I was not going to do something bad. I know it is against your nature, but it is difficult to swim upstream.

Lewis

[luv2glyd]

Hi Lewis,

Thanks for your feedback - very helpful information.