Click here to Skip to main content
Rate this: bad
good
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.
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
Posted 20-Aug-12 14:50pm
Edited 20-Aug-12 15:06pm
v2
Comments
Kenneth Haugland at 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 at 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?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

ie.Document.all(ButtonClickID).Click
 
Pretty much the easy way of doing this.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can check this Excel Silverlight[^] component, it can enable you to work with or without Excel automation.
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 460
1 Sergey Alexandrovich Kryukov 336
2 Shai Vashdi 294
3 OriginalGriff 280
4 Abhinav S 160
0 Sergey Alexandrovich Kryukov 9,185
1 OriginalGriff 5,315
2 Peter Leow 4,040
3 Maciej Los 3,535
4 Abhinav S 3,308


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 4 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid