How to Run an Excel Macro in ArcView 3x


Author:Caitlin Dempsey • 4/16/00 • Categorized as Software          

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.



More articles by:


Article originally published: 4/16/00

« | Main | »

Leave a Response related to the post. Comments that are not related to the post, contain spam, asking for jobs, or do not meet the standards of common decency will not be approved.