Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading html when hyperlink address not hyperlink text diplayed
The following code works only when the value of E16 is the filename plus path. I need E16 to be a hyperlink such that the display value is different from the actual filename plus path; e.g., display = Metadata, filename plus path = C:\My Documents\demo.htm
How would I modify this code to make this work Thanks Kevi Sub Demo( Dim ie As Objec Dim nFile As Intege Set ie = CreateObject("InternetExplorer.Application" With i .Visible = Fals .Silent = Tru .Navigate Worksheets("Sheet1").Range("E16").Selec Do Until Not .Bus DoEvent Loo Worksheets("Sheet1").Range("E1") = .Document.DocumentElement.InnerTex .Qui End Wit Set ie = Nothin End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from html to specific worksheet | Excel Discussion (Misc queries) | |||
Convert Inserted HTML text as Hyperlink | Excel Worksheet Functions | |||
Seperating hyperlink address from viewable text | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink-Programable replacement of Text with Its Actual Address | Excel Worksheet Functions |