I have been stuck on this problem for some time now. Not sure which board this belongs in either. First I need to give some background to my project. I am doing a utility GIS for an entire college campus. Each utility type (Electric, Sanitary, Storm, etc.) have blocks identifying information going to structure found for the respective utility. For example, the storm sewer utility has a curb inlet with a block next to it that has the unique ID number, utility type and location associated for that one particular structure. These are set as attributes for the block.
What I want to happen is when someone clicks on a block, say the block next to the curb inlet for storm sewer, an Excel sheet opens and the value of one cell changes depending on the particular block. That one cell then updates the sheet to display all the data about that one particular structure through VBA which I have already completed. I am under the assumption that this block attribute is what actually communicates with Excel.
Where I am stuck is I have no idea how to make AutoCAD open Excel and then change the value of a cell depending on the block the user clicked on. Is there a way to accomplish this?
From what I have gathered so far, this might be done through either an AutoLISP or VB.NET using MS Visual Studio. I have zero experience with both and honestly I have no idea what the difference is between the two possible solutions.
Any help on this problem would be greatly appreciated.
Thanks,