internet explorer - VBA code to interact with specific IE window that is already open -


I have to find out how to extract VBA to interact with a specific IE window, which is already Is open

My process here:.

When I open IE, navigate to the website, enter your user name and click on PW, click on a new IE window opens I use to enter member number and for membership information Search

I am trying to create a VBA script which will interact with the IE window that opens after successfully logging (starting to automate some more worldly tasks I have seen many tutorials online to see how VBA has to open a new IE window, and then interact with it. However, I am really struggling to get information about how to select a specific already open IE window and interact with it.

I have tried to see this as a quick test whether I can select the correct IE window as an object on which I can talk.

sub-getIE () as a slower object, in the form of Owin object, object set as IE = CreateObject ("Shell.Application") in sh.Windows for each Owin Then TypeName (oWin.document) = "HTMLDocument" then the end then the next MsgBox IE.document.URL set for the end sub IE = Owin exit

the message box appears and the initial IE shows the URL for the window, but I do not know how to get it to select the IE window, which I usually get the member

I used to have many technical classes before when I was in school, but it is late because I have turned some technical muscles to welcome any kind of help. Will be done!

What I use here, it calculates the number of IE's open examples, and then every example Steps through and determines the URL and the title of the web page. After this, you can compare title or URL comparison of title or URL. The following examples compare the title using the "Like" function, but like I said you can compare the URL if you want, besides that, you do not have a title or URL that changes you "=" Instead of "like" 

  marker = 0 set objShell = CreateObject ("Shell.Application can be used to see") IE_count = objShell.Windows.Count for x = 0 (to IE_count - 1) Error resume next Next 'Sometimes more web pages are counted compared to my_url = objShell.Windows (X). Document.Location my_title = objShell.Windows (X). Document. If the title is like my _title "XYZ" & amp; "*" Then to find 'if' the desired web page is already set open ie ie objShell.Windows (x) marker = 1 or else exit the marker = then MsgBox ("a matching webpage Was not found ") either msgbox (" a matching webpage was found ") if

Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more