The document object model doesn't psermit a copy/paste operation, but you can access the individual rows/cells and get the content
from selected ones...
Eg:
Msgbox oTable.rows(2).cells(2).innerHTML
Tim
--
Tim Williams
Palo Alto, CA
"tmp2100 via OfficeKB.com" <u21084@uwe wrote in message news:5f696cb675e15@uwe...
Tim:
I also found that changing the statement:
set oTable=oDoc.getElementById("abcTab")
to:
set oTable=oDoc.document.getElementById("abcTab")
also works as an alternative to your fix.
Now that oTable is set to the correct element, what statement(s) are needed
to cause the contents of oTable to be pasted back to the Excel spreadsheet
from which this macro is being run ?
================================================== ================
Tim Williams wrote:
Sorry, my mistake in the function.
Set retVal = o
should be:
Set retVal = o.document
Tim
Tim:
This appears to work. If I monitor the value of oDoc, the
[quoted text clipped - 55 lines]
endSub
--
tmp2100
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200604/1