How to Run an Excel Macro in ArcView 3x

| |

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

Difficulty Level: Average    Time Required: 10 minutes

Here’s How:

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


Share this article

Enter your email to receive the weekly GIS Lounge newsletter: