VBA - Use data not loaded in ArcMap - Use data directly from source?

ShaunConway

Good Morning - Thanks in advance for the help.

I'm a novice at VBA and need some help in what may be a simple question.

I have written some code that incorporates an event listener, which when triggered, spatially intersects the newly created point with a polygon layer. The attribution from this polygon layer is then used to populate a corresponding field in the point layer. The use of this tool generated interest from other users. They would now like to run this same process iteratively, collecting attribute values from a series (10+) of polygon layers whenever a new point (address point) is created.

I have expanded the tool to make this possible, however, it requires that the source (polygon) layers be within the map document. Is there a way to do this without having all of the source layers loaded in the map document? Can I call the data directly from the sql db?

ShaunConway

The ArcGIS Desktop applications are built using ArcObjects.  The Add Data command uses workspace factories, workspaces, feature classes, etc. when adding data to the map.  Not having the data already in the map will affect performance because more time is needed to make the data connections.  Other than that, it should work pretty much the same.

Thanks again Neil - I've got the code changes made and functioning.