topic ESRI add-in for MS Excel in ArcGIS for SharePoint Questions https://community.esri.com/t5/arcgis-for-sharepoint-questions/esri-add-in-for-ms-excel/m-p/117742#M275 <HTML><HEAD></HEAD><BODY><P>I have recently began working with the Esri add-in for excel<BR />(2010, 32 bit, Windows 7 Professional) and am attempting to get the map window<BR />to copy via a macro (Form Control) to a different print area on the same<BR />worksheet. I would like to maintain the actual base map separate from the<BR />copied image. </P><P>I can make this happen after I initially record the macro,<BR />but each time after, it only works based on what’s manually added to the clipboard (will not refresh</P><P>dynamically). I am assuming this would need to be handled using VBA. Is anyone able to offer<BR />direction on how to continually select/copy the map area each time the macro is<BR />ran? I know this can be done manually, but wanted to streamline, I ran into<BR />a similar problem when I embedded a web browser into Excel.&nbsp; </P></BODY></HTML> Mon, 06 Apr 2015 15:15:20 GMT JaredOdom 2015-04-06T15:15:20Z ESRI add-in for MS Excel https://community.esri.com/t5/arcgis-for-sharepoint-questions/esri-add-in-for-ms-excel/m-p/117742#M275 <HTML><HEAD></HEAD><BODY><P>I have recently began working with the Esri add-in for excel<BR />(2010, 32 bit, Windows 7 Professional) and am attempting to get the map window<BR />to copy via a macro (Form Control) to a different print area on the same<BR />worksheet. I would like to maintain the actual base map separate from the<BR />copied image. </P><P>I can make this happen after I initially record the macro,<BR />but each time after, it only works based on what’s manually added to the clipboard (will not refresh</P><P>dynamically). I am assuming this would need to be handled using VBA. Is anyone able to offer<BR />direction on how to continually select/copy the map area each time the macro is<BR />ran? I know this can be done manually, but wanted to streamline, I ran into<BR />a similar problem when I embedded a web browser into Excel.&nbsp; </P></BODY></HTML> Mon, 06 Apr 2015 15:15:20 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/esri-add-in-for-ms-excel/m-p/117742#M275 JaredOdom 2015-04-06T15:15:20Z