Windows 10: VBA test macro

I am looking for help for the active page which loads after the submit button as need to enter the next data but its not working------------Option ExplicitConst sSiteName = "https://www.help.com/"Private Sub CommandButton1_Click Dim oIE As Object Dim oHDoc As HTMLDocument Set oIE = CreateObject"InternetExplorer.Application" ' Open Internet Explorer Browser and keep it visible. With oIE .Visible = True .Navigate sSiteName End With While oIE.ReadyState <> 4 DoEvents Wend Set o

:)

 

Macros (VBA) function in window phones

I am looking for Macros (VBA) to operate in window phones. That will boost up productivity drastically. As, for many of the jobs, customized reports can be taken on phone itself making on-the-way time utilization.

Thanks ...

Regards

Sanjay Kulkarni

*** Email address is removed for privacy ***

 

123456 vba

How to automate already Opened IE browser using excel Macros?

Steps:
Step 1: Open VBA editor on a new excel file and create a new module.
Step 2: Copy below code in the vba module.

Sub accessExistingIEBrowser()

On Error Resume Next

boolWindowFound = False
Set objShell = CreateObject("Shell.Application")
WinCount = objShell.Windows.Count
For winNo = 0 To (WinCount - 1)

strURL = objShell.Windows(winNo).document.Location
strTitle = objShell.Windows(winNo).document.Title
If strTitle Like "Sample Form" Then
Set IE = objShell.Windows(winNo)
boolWindowFound = True
Exit For
Else
End If

Next

If boolWindowFound Then
Set doc = IE.document
doc.getElementsByName("fname")(0).Value = "test"
End If

End Sub

-----------------------------------

How to automate data entry on a Web page using excel macros?

Pre-requisites:

1 . On the Macro Window, Insert a new module
2. Go to Tools/References
3. Select Microsoft Internet Controls
4. Select Microsoft HTML Object Library

Sample code given below:

Sub dataEntry()

Dim IE As Object
Dim doc As HTMLDocument

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

IE.Navigate "Lets Automate"

Do While IE.Busy Or IE.ReadyState <> 4
Application.Wait DateAdd("s", 1, Now)
Loop

Set doc = IE.Document

doc.getElementById("num1").Value = 5
doc.getElementById("num2").Value = 4
doc.getElementById("btnCalculate").Click


End Sub

 

RUN A MACRO FROM WITHIN ANOTHER MACRO

Google "knows" when you ask it like so:

how to launch an excel macro from a macro

and it points you to
this page.