Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Paste Plain Text
#1
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)


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)