Hi Rick,
I'd be delighted to give you more details. Thank you for taking an interest
I appreciate it.
I am working with an in-house (partly) developed Document Management
program. I have no control over the program development but do have to work
with the limited results it produces.

I need to compile a report based on document statistics fields displayed in
a search results screen. I cannot print or export the report.
I found however that by copying the report window to the clipboard and
pasting the results as text, I am able to identify the location of the
various fields.

The number of characters and the positions of the fields never varies.
I want to quickly identify the character position of the starts of each of
these fields so that I can extract them and place them into an Excel
Spreadsheet. I haven't counted the length of the string on the clipboard but
I suspect that there are some 500 characters

As a one off exercise, by copying the contents (character by character into
column A of a sheet I can quickly identify the start and end position of all
my fields.
For example: In the string "The quick brown fox"
The word fox starts in cell A17

I can use that info with VBA InStr commands against the contents of the
clipboard to extract text based on start positions and length & place them
in a structured spreadsheet.

Hope that is a little clearer and I'm sorry ofr the earlier brevity.

Thanks again

Phil








"Rick Rothstein (MVP - VB)" wrote in
message ...
Explain what you are trying to ultimately accomplish in more detail (that
is, what do you want to see or have at the end of the process)... my guess
from your initial post is you can probably do what you want without
involving the clipboard (and, depending on what you want for a final
outcome, maybe without putting anything into the worksheet either), but
without knowing what your desired final usage is, it is kind of hard to
say. Don't fix on the solution you "think" you need to do; rather, tell us
the final outcome you want to see (minus any temporary stuff you imagine
you need).

Rick


"PPL" wrote in message
news:jHgyj.28921$w94.21453@pd7urf2no...
Has anyone any ideas please on how to paste the contents of the clipboard
one character at a time into an excel sheet row by row
I'm looking for a way to count the character positions of selected text?

TIA

Phil