Windows 10: KB5032190 Crashes the VBA macro editor in Access 2007d

After this update KB5032190 when trying to write something in the Microsoft Access 2007 macro editor VBA, the editor crashes.Uninstalling KB50302190 resolves the issue.

:)

 

Software and VBA Compatibility

I develop a lot of macros and code in VBA for Access and Excel on my PC. I'm also a big R user, and want to get MatLab at some point too.

So, my question is, would upgrading to Windows 10 affect:

VBA editor, object models, dlls, etc

R and the RExcel add-in

MatLab

Excel and Access themselves

My hunch is "no" but I need to make sure.

 

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

 

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 ***