View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default How can I copy formatted text from an Excel textbox into an IE .htm document ?

Charles,

It's not clear exactly what you're doing (missed your previous posts). Do
you want to open an html page in IE and then transfer some information to
textboxes within the page?

Need more details...

tim

"Charles Jordan" wrote in message
m...
Thanks to Jake Marx who has come up with a brilliant piece of code in
this NG I am now able to call Internet Explorer via an Excel button.
We have around 1,000 text boxes, and within each textbox formatted
text - different font sizes, colours, and carriage returns.

At the moment we are copying and pasting all this stuff manually in to
an .htm document in, and then reformatting it also in Word. Does any
one know a way of automating this hugely laborious task ? We are able
to use a For - Next loop to get at every textbox, but what should go
into the loop, please ?

TIA - Charles Jordan