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:

  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.


Like this article and want more?

Enter your email to receive the weekly GIS Lounge newsletter: