Click here to Skip to main content
15,881,690 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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 ====

VB
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
Posted
Updated 20-Aug-12 15:06pm
v2
Comments
Kenneth Haugland 20-Aug-12 21:12pm    
1. There us a sirious bug on your cite.
2. Excel automation works with Interop or OleDb. But for such an application I would create a WCF service that communicates with the server, with the Excel automation happening inside WCF. Excel reading is knwn to caulse all kinds of problem, with different versions, and it could be tricky to accomodate all users local Excel app. The servers application would be completely under your control..
Jefferson Daniel 20-Aug-12 21:43pm    
Well the tools were using requires the Maricopa assessor, and I certainly don't get paid enough to develop my own assessor app lol Is there any record of excel automating silver-light apps that I could at-least try?

1 solution

ie.Document.all(ButtonClickID).Click


Pretty much the easy way of doing this.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900