Hello Vixer
As always, the main problem is that you either cannot explain what you want, or don’t understand yourself what you want or what you are doing. Probably a bit of both.
Never mind, stay cool Bro, an lets move on….
I have tried to do some analysis of your 2 supplied “csv files” Before and After , here : https://excelfox.com/forum/showthrea...ll=1#post13208
I am probably wasting my time trying to explain what Sandy also is trying to explain…
csv means
comma separated values
__ , __ separated values
https://en.wikipedia.org/wiki/Comma-separated_values
Your supplied files ( From here: https://excelfox.com/forum/showthrea...ll=1#post13193 https://drive.google.com/file/d/1MFI...LjkblGxfo/view https://drive.google.com/file/d/1V_8...Sd5zlDcVX/view ) are not csv files
I do not know what they are. Maybe we can call them Tab delimited or Tab separated. Or we can call them dog shit files
I will now modify my last macro so that it makes the DogShit file that you want
The macro will produce two files:
2.csv
DogShit.txt
We do not open 2.csv or DogShit.txt … We make them !
Do not open 2.csv in the macro!!!! Do not put a code line in the macro to open 2.csv!!! ( You can open manually later with text editor or Excel )
Here is the macro : https://excelfox.com/forum/showthrea...ll=1#post13217
After you run that macro , you will see two new files:
New made Dog Shit files.JPG : https://imgur.com/UUZ09z6
New made Dog Shit files.jpg
Those two files, which my latest macro produces, are identical to your supplied After csv file
After csv.JPG : : https://imgur.com/IzaxRrh
( https://drive.google.com/file/d/1V_8...Sd5zlDcVX/view )
After csv.JPG
I must go now , dig a big hole and pull some teeth out for relaxation ( https://imgur.com/8mV1o8q ) ,
Tomorrow I will look in again here ….
Alan
Share ‘1.xls’ : https://app.box.com/s/38aoip5xi7018y9syt0xe4g04u95l6xk
Share ‘macro.xlsm’ : https://app.box.com/s/599q2it3uck3hfwm5kscmmgtn0be66wt
Share ‘3.xlsx’ : https://app.box.com/s/8k9b556duom523b381m80oeixonp0042
Reply With Quote
Bookmarks