How to Run an Excel Macro in ArcView 3x

Caitlin Dempsey


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.


Photo of author
About the author
Caitlin Dempsey
Caitlin Dempsey is the editor of Geography Realm and holds a master's degree in Geography from UCLA as well as a Master of Library and Information Science (MLIS) from SJSU.