Click here to Skip to main content
13,046,087 members (51,712 online)
Rate this:
Please Sign up or sign in to vote.
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.

======= 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 = ""
    ie.Visible = True
        While ie.Busy

        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 20-Aug-12 14:50pm
Updated 20-Aug-12 15:06pm
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

Rate this: bad
Please Sign up or sign in to vote.

Solution 2


Pretty much the easy way of doing this.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 26 May 2015
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100