As promised in my Inspire session (Data Is the New Oil. Come Wildcat for Geospatial Crude), I have published the two macros I demonstrated.Stream Online Shapefile - this macro requires that the freeware compression software 7-Zip (download here) be installed
Get ArcGIS REST layer
@Hollingsworth I'm having the same issue accessing the module, the link no longer works
Thanks for your interest. I've made some modifications to the macro and have yet to document them enough to put onto the Gallery. Please stand by as I finish it up.