I have recently began working with the Esri add-in for excel
(2010, 32 bit, Windows 7 Professional) and am attempting to get the map window
to copy via a macro (Form Control) to a different print area on the same
worksheet. I would like to maintain the actual base map separate from the
copied image.
I can make this happen after I initially record the macro,
but each time after, it only works based on what’s manually added to the clipboard (will not refresh
dynamically). I am assuming this would need to be handled using VBA. Is anyone able to offer
direction on how to continually select/copy the map area each time the macro is
ran? I know this can be done manually, but wanted to streamline, I ran into
a similar problem when I embedded a web browser into Excel.
