How to Run an Excel Macro in ArcView 3x

Caitlin Dempsey

Major content update: April 16, 2000

Minor updates: April 16, 2000

GIS Software

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.

Caitlin Dempsey

Caitlin Dempsey is a geographer, writer, and founder and editor of Geography Realm. She holds bachelor's and master's degrees in Geography from UCLA and a Master of Library and Information Science (MLIS) from San José State University.

For more than two decades, she has written about geography, maps, geographic information systems (GIS), remote sensing, satellite imagery, and environmental science. Her work focuses on making geography accessible to a broad audience through articles, tutorials, and educational resources.

LinkedIn | Instagram