Quote Originally Posted by p45cal View Post
Excel won't know that wdFormatText is 2 and wdCRLF is 0, an that wdDoNotSaveChanges is also 0, so substitute those bits for the numbers.
I had a similar issue - looking at your reply, I realised I had just copied my Word VBA code straight to Excel without even thinking about converting the the constants - thank you so much for this.