Using Avenue, you can easily run Excel Macros from within ArcView.
Difficulty Level: Average Time Required: 10 minutes
- 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.