Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Pasting Data into a webpage text box

Simon move my posting at the codecage from excel to word so i'm reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word document to a
webpage with a box similar to the message box I'm presently typing in. The
webpage doesn't allow modifying the innertext or innerHTML. I saved the word
document to HTM file format. I then open the html file as a text file and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was thinking of
just replacing the body protion of the outterhtml but I can't even find the
body tags and don't think this will work. Any suggestions on the best
approach. I know from looking at the proerties of the obx object is does
allow pasting but not sure the syntax to copy the data from the DOC into the
webpage object.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default Pasting Data into a webpage text box

Joel, instead of saving as a webpage; usign the word object cant you read
from the word doc directly . Simon would have moved this to MSword group
considering this option.

"Joel" wrote:

Simon move my posting at the codecage from excel to word so i'm reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word document to a
webpage with a box similar to the message box I'm presently typing in. The
webpage doesn't allow modifying the innertext or innerHTML. I saved the word
document to HTM file format. I then open the html file as a text file and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was thinking of
just replacing the body protion of the outterhtml but I can't even find the
body tags and don't think this will work. Any suggestions on the best
approach. I know from looking at the proerties of the obx object is does
allow pasting but not sure the syntax to copy the data from the DOC into the
webpage object.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Pasting Data into a webpage text box

How? I know how to copy from a wor document, but HOW do you paste into a IE
explorer object?

"Jacob Skaria" wrote:

Joel, instead of saving as a webpage; usign the word object cant you read
from the word doc directly . Simon would have moved this to MSword group
considering this option.

"Joel" wrote:

Simon move my posting at the codecage from excel to word so i'm reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word document to a
webpage with a box similar to the message box I'm presently typing in. The
webpage doesn't allow modifying the innertext or innerHTML. I saved the word
document to HTM file format. I then open the html file as a text file and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was thinking of
just replacing the body protion of the outterhtml but I can't even find the
body tags and don't think this will work. Any suggestions on the best
approach. I know from looking at the proerties of the obx object is does
allow pasting but not sure the syntax to copy the data from the DOC into the
webpage object.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default Pasting Data into a webpage text box

http://msdn.microsoft.com/en-us/libr...19(VS.85).aspx

Tim


"Joel" wrote in message
...
How? I know how to copy from a wor document, but HOW do you paste into a
IE
explorer object?

"Jacob Skaria" wrote:

Joel, instead of saving as a webpage; usign the word object cant you read
from the word doc directly . Simon would have moved this to MSword group
considering this option.

"Joel" wrote:

Simon move my posting at the codecage from excel to word so i'm
reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word document
to a
webpage with a box similar to the message box I'm presently typing in.
The
webpage doesn't allow modifying the innertext or innerHTML. I saved the
word
document to HTM file format. I then open the html file as a text file
and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was thinking
of
just replacing the body protion of the outterhtml but I can't even find
the
body tags and don't think this will work. Any suggestions on the best
approach. I know from looking at the proerties of the obx object is
does
allow pasting but not sure the syntax to copy the data from the DOC
into the
webpage object.



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Pasting Data into a webpage text box

Tim still not working. I tried a lot of things. I using excel VBA and added
references for the Microsoft Internet Controls and Microsoft html object
library. I think the correct method should be HTMLpaste but not sure what
object to use.

I presently have the following
Set documentBody = IE.document.getelementbyid("compose_editorArea")
documentBody.document.body.pastehtml (HTMLText)

"Tim Williams" wrote:

http://msdn.microsoft.com/en-us/libr...19(VS.85).aspx

Tim


"Joel" wrote in message
...
How? I know how to copy from a wor document, but HOW do you paste into a
IE
explorer object?

"Jacob Skaria" wrote:

Joel, instead of saving as a webpage; usign the word object cant you read
from the word doc directly . Simon would have moved this to MSword group
considering this option.

"Joel" wrote:

Simon move my posting at the codecage from excel to word so i'm
reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word document
to a
webpage with a box similar to the message box I'm presently typing in.
The
webpage doesn't allow modifying the innertext or innerHTML. I saved the
word
document to HTM file format. I then open the html file as a text file
and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was thinking
of
just replacing the body protion of the outterhtml but I can't even find
the
body tags and don't think this will work. Any suggestions on the best
approach. I know from looking at the proerties of the obx object is
does
allow pasting but not sure the syntax to copy the data from the DOC
into the
webpage object.



.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default Pasting Data into a webpage text box

Without knowing what's in that iframe it's hard for me to suggest other
approaches.
If you want to send me the HTML off-line then I can take a look

Tim
tim j williams at gmail dot (etc) no spaces

"Joel" wrote in message
...
Tim still not working. I tried a lot of things. I using excel VBA and
added
references for the Microsoft Internet Controls and Microsoft html object
library. I think the correct method should be HTMLpaste but not sure what
object to use.

I presently have the following
Set documentBody = IE.document.getelementbyid("compose_editorArea")
documentBody.document.body.pastehtml (HTMLText)

"Tim Williams" wrote:

http://msdn.microsoft.com/en-us/libr...19(VS.85).aspx

Tim


"Joel" wrote in message
...
How? I know how to copy from a wor document, but HOW do you paste into
a
IE
explorer object?

"Jacob Skaria" wrote:

Joel, instead of saving as a webpage; usign the word object cant you
read
from the word doc directly . Simon would have moved this to MSword
group
considering this option.

"Joel" wrote:

Simon move my posting at the codecage from excel to word so i'm
reposting at
MS so it appears where I wanted the posting.

I'm working om a Webpage project where I'm copying from a word
document
to a
webpage with a box similar to the message box I'm presently typing
in.
The
webpage doesn't allow modifying the innertext or innerHTML. I saved
the
word
document to HTM file format. I then open the html file as a text
file
and
perform a readall. Then simply move it to the outter html

IE.myobject.outterhtml = fs.readall

This destroys the box and just displays the tagged data. I was
thinking
of
just replacing the body protion of the outterhtml but I can't even
find
the
body tags and don't think this will work. Any suggestions on the
best
approach. I know from looking at the proerties of the obx object is
does
allow pasting but not sure the syntax to copy the data from the DOC
into the
webpage object.



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting into a Webpage Message box joel[_245_] Excel Programming 3 November 22nd 09 05:49 PM
Pasting data as 'text' from 2 different applications Marta Excel Discussion (Misc queries) 0 March 9th 09 10:49 AM
Copying and pasting tabular text data fk Excel Discussion (Misc queries) 0 July 22nd 08 11:06 PM
Get Webpage data as text using VBA w/o Webquery Max Excel Programming 0 March 15th 07 06:40 AM
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"