Hi all,
I am experiencing a strange behaviour from my Excel.
If I am opening manually a *.csv file, the file opens in 1 column with all the text as is in the CSV-file (when opened in Notepad as txt).
However if I open with a macro, the file is upon opening already converted and divided in columns. (This has changed recently and I cannot figure out why)
For me this is at the moment unwanted, as my macro is dealing with the text in one column. And as side-effect, the date-labels are completely messed up. Like 14th october = 14-10-2021, but 1st of october is displayed as 10-01-2021 (like 10th of January)
How is this this behavior to be avoided? I mean that the file should be opened as before (i.e. manually), as text in one column in VBA.
Cheers
Erwin
Bookmarks