I would like to be able to edit a webpage using a microsoft word
command in internet explorer and save the document in print format
(which is at bottom of the webpage). I want to do this within an Excel
macro which will continue on with other commands, etc.

I have found code in this group( posted by Jake Marx of
www.longhead.com) which will bring up the page (code shown below)
But I don't know how to invoke the command in ie under file:
edit with Microsoft Word (some ie seem to have the command edit with
Microsoft Frontpage - this may have to do with what word version you
are running)
After invoking the command edit with Microsoft word I would like to
save the page with the command at the bottom of the page, format for
printing.
Any help or where I can get help would be appreciated.
Thanks
Don


Sub test()
'This routine calls the function GETURLPAGETITLE
r = GETURLPAGETITLE("valueclick.com")
MsgBox r

End Sub
Public Function GETURLPAGETITLE(sURL As String) As String
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate sURL
Do Until ie.ReadyState = 4
DoEvents
Loop
GETURLPAGETITLE = ie.Document.Title
ie.Quit
Set ie = Nothing
End Function

Don

Just to get my understanding:

you want a button an the excel toolbar that will change open a weblink (from
a fixed cell in excel) in word to allow you to edit the page and then save
the updated page.

the reason why ie open frontpage is becasue there is an option in ie to
define the default editor (look at Tools|Internet Optioons|Programs).

what do you mean by saving the page as print format?

This will give me more info to help.
--
Hope this helps
Martin Fishlock


"don" wrote:

I would like to be able to edit a webpage using a microsoft word
command in internet explorer and save the document in print format
(which is at bottom of the webpage). I want to do this within an Excel
macro which will continue on with other commands, etc.

I have found code in this group( posted by Jake Marx of
www.longhead.com) which will bring up the page (code shown below)
But I don't know how to invoke the command in ie under file:
edit with Microsoft Word (some ie seem to have the command edit with
Microsoft Frontpage - this may have to do with what word version you
are running)
After invoking the command edit with Microsoft word I would like to
save the page with the command at the bottom of the page, format for
printing.
Any help or where I can get help would be appreciated.
Thanks
Don


Sub test()
'This routine calls the function GETURLPAGETITLE
r = GETURLPAGETITLE("valueclick.com")
MsgBox r

End Sub
Public Function GETURLPAGETITLE(sURL As String) As String
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate sURL
Do Until ie.ReadyState = 4
DoEvents
Loop
GETURLPAGETITLE = ie.Document.Title
ie.Quit
Set ie = Nothing
End Function

I don't need to edit the page, just save the page as a word document.
So your first paragraph is correct except the need to edit the page.

The page I am trying to save is from the programs found on
www.bugzilla.org.
At the bottom of the page it allows you to save in a print format.
I would like to do that as well.

any help would be appreciated.
Don


On Thu, 23 Nov 2006 18:37:01 -0800, Martin Fishlock
wrote:

Don

Just to get my understanding:

you want a button an the excel toolbar that will change open a weblink (from
a fixed cell in excel) in word to allow you to edit the page and then save
the updated page.

the reason why ie open frontpage is becasue there is an option in ie to
define the default editor (look at Tools|Internet Optioons|Programs).

what do you mean by saving the page as print format?

This will give me more info to help.

Don,

I would suggest that the easiest way to do it is to save the page from IE
and then load it in word afterwards.

--
Hope this helps
Martin Fishlock


"don" wrote:


I don't need to edit the page, just save the page as a word document.
So your first paragraph is correct except the need to edit the page.

The page I am trying to save is from the programs found on
www.bugzilla.org.
At the bottom of the page it allows you to save in a print format.
I would like to do that as well.

any help would be appreciated.
Don


On Thu, 23 Nov 2006 18:37:01 -0800, Martin Fishlock
wrote:

Don

Just to get my understanding:

you want a button an the excel toolbar that will change open a weblink (from
a fixed cell in excel) in word to allow you to edit the page and then save
the updated page.

the reason why ie open frontpage is becasue there is an option in ie to
define the default editor (look at Tools|Internet Optioons|Programs).

what do you mean by saving the page as print format?

This will give me more info to help.