|
Posted by Me on October 3, 2007, 12:36 pm
Please log in for more thread options
Simon wrote:
> In short - is this possible?
>
> I have an excel worksheet with the fields as rows, and a user inputs
> values in the relevant columns and saves it.
>
> I have created a form in ArcGIS - I would like to click the load
> button, which prompts for location of spreadsheet, and then once
> selected, it will pluck out the relevant cell-values from the
> worksheet and dump them in the relevant text-boxes in the form.
>
> I have not seen this done before with Excel. Any pointers would be
> great.
In VB/VBA:
1) open your form
2) read the Excel file name
3) open it (google it... "VB excel open")
4) read the values ( value = cells(rowID,colID) )
5) write the values into your form
Jean
| 
XML Sitemap