View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default navigating to an unnamed spawned window ?

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