How to convert pipe delimited table data back into proper tables?
We produce accessible format files for blind folks. We strip out all formatting from source files (from OCR etc) in order to start from scratch. I have a procedure/Sub which copies the contents of a file and pastes them into a new document as text, but this also removes tables. I've now added a Sub which turns any tables in the source file into pipe delimited data before pasting as text. But I need help writing VBA to convert these lines of pipe delimited data back into proper tables. Any help would be very much appreciated.