Hello Happy Excel Users!
I have a bit of a weird problem. I have made an analyser for WhatsApp in Excel, but it is very system heavy, so I thought I would make it in VBA to ease calculations.
Most of that process is straight forward, but I have run into a weird problem. When I manually open and copy-paste from the exported .txt file, the conversations are pasted as 1-column data with a message on each row. That's good and workable!
However, any method I have tried with VBA pastes the .txt contents as all in one cell - not good. I'd really like the user to be able on just choosing the file in FSO and have the database made. The problem of the .txt file seems to be that it is not delimited in any specific manner... How copy-paste Excel handles that, I have no idea.
Any advise on how to do this?
Attachments here won't work (it's blank, weird), so here's a link to a small WhatsApp exported file: https://1drv.ms/t/s!ArSYCsSUTeLolYhhZ-OPIwgA226a2w
Thank You,
GregersDK
Bookmarks