11-07-2008, 04:01 PM
I need to copy from an Excel cell - or any other source, strip out all rich text attributes, and paste:
I have Excel 2007 and an old finicky Access 2000 program that runs on the old Access 2000 runtime.
I have a macro that pastes the clipboard contents into the Access program for a search function. But seems to only read plain text. If I paste from Excel it pastes, and looks right, but finds nothing.
Type in the exact same string manually, and there is no problem.
So:
Is there a way to make the contents of the current clipboard into plain text?
I think this will solve my issue (I sure hope so)
I have Excel 2007 and an old finicky Access 2000 program that runs on the old Access 2000 runtime.
I have a macro that pastes the clipboard contents into the Access program for a search function. But seems to only read plain text. If I paste from Excel it pastes, and looks right, but finds nothing.
Type in the exact same string manually, and there is no problem.
So:
Is there a way to make the contents of the current clipboard into plain text?
I think this will solve my issue (I sure hope so)