I'm working on a project that I could use some help on. Here's what I want to do:
Enter a district office number into a custom property within a sheet set. Have that flag an event that takes that number, compares it to an external xls file containing a list of offices and their addresses. Take the corresponding record from the xls file and populate the district address info into the appropriate custom properties of the sheet set.
I'm quite familiar with VBA for AutoCAD but I haven't found any good info on the Sheetset API. Any help, information, and/or suggestions would be appreciated.
BTW, I can interface with an open xls file in Excel fairly well but it would be ideal if anybody could suggest a way to interface with the xls file without having to open it. Thanks!