How to Run an Excel Macro in ArcView 3x

Sunday April 16th 2000
Filed Under 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.

[Post to Twitter]  [Post to Delicious]  [Post to Digg]  [Post to Reddit]  [Post to StumbleUpon] 




Read More

  • ArcView 3.x Developer Resources
  • Mapping Excel Data Using Google Maps and Earth
  • ArcView (ArcGIS)
  • Creating Simple Maps with Microsoft Excel
  • Symbol Sets for ArcView 3x and ArcInfo 7x
  • « Conservation Biology and GIS | Main | GIS Day: A Celebration »


    Comments

    Leave a Reply