View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tmp2100 via OfficeKB.com tmp2100 via OfficeKB.com is offline
external usenet poster
 
Posts: 3
Default navigating to an unnamed spawned window ?

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