So Im sort of working in VB Script / Excel, and in Excel the following code below works fine in any browser and most website. What I'm trying to do is have my excel sheet, which contains address's and parcels, to export the variables from excel, and insert it into the search on the county assessors. This worked great for most county's. One county though uses Silverlight as there application.
Can excel do something similar with Silverlight apps, and load up the app, and autofill the search with the address.
The site is below if you want to play around with it.
http://maps.mcassessor.maricopa.gov/maps/default.aspx
======= Hypothetically This would be the code if it worked with this Assessor ====
Sub EnterSite()
Dim Parcel As String, Parcel2
Application.GoTo (ActiveWorkbook.Sheets("Sheet1").Range("R6"))
Parcel = ActiveCell.Text
'MsgBox (Parcel)
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate = "http://maps.mcassessor.maricopa.gov/maps/default.aspx"
ie.Visible = True
While ie.Busy
DoEvents
Wend
ie.Document.all("SearchStringTextBox").Value = Parcel
End Sub
I used the program Silver-light Spy to view the textbox associated with the search and its name variable was "SearchStringTextBox" but it never worked when I tried it.
If this is possible, you would be a lifesaver in helping me. I know excel does quite a bit, But I couldn't find any solutions to this relating to silver light.
Thanks In Advance