使用Excel自动填充Silverlight表单 [英] Using Excel To Autofill Silverlight Forms

问题描述

所以我在VB Script / Excel中工作，在Excel中，以下代码在任何浏览器和大多数网站中都能正常工作。我要做的是让我的Excel工作表（包含地址和地块）从excel导出变量，然后将其插入到县评估员的搜索中。这对大多数县来说都很有用。一个县虽然使用Silverlight作为应用程序。



可以使用Silverlight应用程序执行类似操作，并加载应用程序，并使用地址自动填充搜索。



如果您想玩它，该网站在下面。

http://maps.mcassessor.maricopa.gov/maps/default.aspx



=======假设这是代码，如果它适用于此评估员====

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

我用程序Silver-light Spy查看文本框与搜索及其名称变量相关联的是SearchStringTextBox，但是当我尝试它时它从未起作用。



如果可以的话，你将成为帮助我的救星。我知道excel确实做了很多，但我找不到任何与银光相关的解决方案。



先谢谢

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

推荐答案

ie.Document.all(ButtonClickID).Click

这很简单。

Pretty much the easy way of doing this.

这篇关于使用Excel自动填充Silverlight表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！