LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
don don is offline
external usenet poster
 
Posts: 15
Default Editing and Saving webpage

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
 
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
Saving as webpage, uploading via FTP Duke Excel Discussion (Misc queries) 0 January 29th 10 10:21 PM
Saving data to a webpage steve New Users to Excel 2 February 24th 08 09:00 PM
excel - hyperlinks to pdf documents and saving as webpage Althea Excel Discussion (Misc queries) 0 July 23rd 07 03:34 AM
Saving worksheet as webpage Aramis Excel Discussion (Misc queries) 1 January 9th 06 10:26 PM
Problems with line tool when saving as a webpage Phil BUtler Excel Discussion (Misc queries) 0 March 15th 05 01:15 AM


All times are GMT +1. The time now is 07:30 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"