Office Automation: Copy range text including soft hyphens from Word to Excel or Access while avoiding clipboard
I’m desparately trying to copy a text inside a cell of a narrow word table including softhyphens produced by MSWord’s AutoHyphenation feature to Excel or Access.
It works, when the softhyphens are already available in the table cell.
Run the attached code in MSWord the first time after uncommenting the commented Code lines: