Automate IE via Excel to fill in a dropdown and continue
Ok, because you wrote you want to understand how it works I have commented the whole code by detail. This is the working code: Sub DeviceSearch() ‘Define constants Const url As String = “https://a810-dobnow.nyc.gov/Publish/#!/” ‘Declare variables Dim ie As Object Dim htmlDoc As Object Dim nodeDeviceTypeDropdown As Object Dim nodeCraneDeviceDropdown As Object Dim nodeCraneDeviceID As … Read more