<div>
Like other browsers IE does not provide the URL in the window title, so finding the corresponding window can get very difficult. The only reliable way to get control is if you start the IE COM object from the application.
</div>


Volunteer

Jim Dettman (EE MVE)

<div>
vba<br />

<pre><code class="code-1 nolinks" id="code-20-43313475-1"><span>obj.DoCmd.SelectObject acForm, &quot;frmnamek&quot;, True</span>
</code></pre>
</div>


<div>
Further to Qlemo's answer, here is the code you would need more or less:<br><br><a href="https://www.experts-exchange.com/articles/2104/Avoiding-running-multiple-instances-of-an-application.html" rel="ugc">https://www.experts-exchange.com/articles/2104/Avoiding-running-multiple-instances-of-an-application.html</a><br><br>This code, rather than using the caption of the window, marks the window with a property. &nbsp; it was meant to prevent multiple instances of the same app running as the title says, but in outline, it's the VBA code you would more or less use to loop through windows and switch to a window.<br><br>As Qlemo said though, really would you should do is control IE through COM.<br><br>Jim.<br><br>
</div>


<div>
This is hard stuff so, &nbsp;I might be very far off the track with the following question.<br><br>Referring to QLEMO's comment<br><em>The only reliable way to get control is if you start the IE COM object from the application.</em><br><br><br>I am using the following declaration and code to open a webpage. &nbsp;If I open up the website in this way, can the info that I need to get at the resultant website (after logon) be retrieved?<br>Thank you.<br><br><pre><code class="code-10 nolinks" id="code-20-43313567-1"><span>Declare Function apiIEsize Lib "user32" Alias "ShowWindow" (ByVal hWnd As Long, ByVal cmdshow As Long) As Long</span>
<span> </span>
<span></span>
<span>Dim IE As Object</span>
<span> Set IE = CreateObject("InternetExplorer.Application")</span>
<span> IE.navigate strUrl</span>
<span></span>
<span>etc etc...</span>
<span></span>
<span>&nbsp; &nbsp;IE.Document.getElementById("USERID").Value = strUserName</span>
<span>&nbsp; &nbsp;IE.Document.getElementById("PASSWORD").Value = strPassword</span>
<span>&nbsp; &nbsp;IE.Document.getElementById("LOGON").Click</span>
<span></span>
<span></span>
<span></span>
</code></pre>
</div>


<div>
No reason you should not be able to. &nbsp;With IE object variable, you can get at anything with various properties and methods (for example, there is also:<br><br><pre><code class="code-1 nolinks" id="code-20-43313635-1"><span>IE.GetElementsByTagName("h1")(0).innerHtml</span>
</code></pre>. &nbsp;You also have the ability to click things in the page to carry out actions, or navigate to a new URL.<br><br>Jim.
</div>


Tech

peispud

<div>
I appreciate your help. &nbsp;This will still be a challenge for me but at least I will be going in the right direction.<br><br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hi.<br>Using Microsoft Access VBA.<br>I may have many window open. I would like to iterate through all the open windows. If my desired windows is open, then I would like to activate it &nbsp;(put it in front of my eyes). &nbsp;In particular, this would be an internet explorer window to a specific URL.<br><br>Thank you
</div>
</div>



Hi.
Using Microsoft Access VBA.
I may have many window open. I would like to iterate through all the open windows. If my desired windows is open, then I would like to activate it  (put it in front of my eyes).  In particular, this would be an internet explorer window to a specific URL.
Thank you

Find / activate window  if it is already open

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Internet Explorer is a series of graphical web browsers first developed by Microsoft Corporation in 1995. It is included in the Microsoft Windows line of operating systems. It was first released as part of the add-on package Plus! for Windows 95.

Internet Explorer (IE)

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.