How to Run an Excel Macro in ArcView 3x

Sunday April 16th 2000
Filed Under ArcView 3x 

Using Avenue, you can easily run Excel Macros from within ArcView.

Difficulty Level: Average    Time Required: 10 minutes

Here’s How:

  1. In ArcView go to Scripts and click “new”.
  2. First make a DDE connection: excel = DDEclient.Make(”Excel”,”Your Spreadsheet Name Here”)
  3. Then run the macro: excel.execute(”[RUN(""Macro_Name_HERE"")]“)
  4. Compile the script.
  5. Test by clicking the run button.





Read More

  • ArcView 3.x Developer Resources
  • ArcView (ArcGIS)
  • Creating Simple Maps with Microsoft Excel
  • Symbol Sets for ArcView 3x and ArcInfo 7x
  • Avenue Scripts

    • « Conservation Biology and GIS | Main | GIS Day: A Celebration »

    Comments

    Leave a Reply