Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with IE
I am a novice and not exactly sure how to get this started. I have an excel
worksheet with a list of URLs in one column. I am wanting to check, insert the URLs into the IE address field, and then return the page name. Any ideas? Thanks, Pablo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with IE
Hi,
This assumes that the URL's are in Column 'A': Public Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) Dim C% Dim SelectedCol$, SelectedRow$ Cancel = True SelectedCol = Left(Target.Address(False, False), 1) SelectedRow = Target.Row Select Case SelectedCol Case "A" C = 1 Case Else C = 0 End Select If C = 1 Then ThisWorkbook.FollowHyperlink Address:= _ ThisWorkbook.Path & Cells(SelectedRow, 1) Else Cells.Rows.Hidden = False End If End Sub HTH--Lonnie M. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with IE
This should do what you want
Set IE = CreateObject("InternetExplorer.Application") Set worklist = Selection.EntireRow.Rows With IE ..Visible = True ..silent = True 'Work the list For Each ticket In worklist ..Navigate "Some webpage" Do Until Not IE.Busy And IE.readyState = 4 ' 4 == READYSTATE_COMPLETE DoEvents Loop 'Set Solution ID your_cell = .Document.Body.Title.Value Next End With |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with IE
oops,
ThisWorkbook.FollowHyperlink Address:= _ ThisWorkbook.Path & Cells(SelectedRow, 1) should be: ThisWorkbook.FollowHyperlink Address:= Cells(SelectedRow, 1) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interacting with IE
Thanks for the info. I am getting a syntax error "..Visible = True" when I
place the code in a sub routine and run it. Is there anything I need to do to set this up? "CodeSponge" wrote: This should do what you want Set IE = CreateObject("InternetExplorer.Application") Set worklist = Selection.EntireRow.Rows With IE ..Visible = True ..silent = True 'Work the list For Each ticket In worklist ..Navigate "Some webpage" Do Until Not IE.Busy And IE.readyState = 4 ' 4 == READYSTATE_COMPLETE DoEvents Loop 'Set Solution ID your_cell = .Document.Body.Title.Value Next End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interacting with 2 different excel files | Excel Discussion (Misc queries) | |||
Problem interacting between VB.NET and VBA6 with Excel 2003 | Excel Discussion (Misc queries) | |||
suspending-interacting-resuming | Excel Programming | |||
Interacting outside Excel | Excel Programming | |||
Interacting with Explorer | Excel Programming |