First some background:

So I work a lot with building (like an actual building, a noun not a verb) were we don't really do individual part drawings just multiple displays of a top level assembly and sub assemblies for building instructions. So I cant really do this by adding a custom properties to the parts or assemblies because the assembly may change but if its at the end of the construction phase it wont affect the previous drawings.      

The problem:

I am trying to come up with a macro that will

     1) Look take the name of the drawing

     2) Open a specific excel file

     3) Find that drawing name and collect the rev information

     4) Then update the rev table

I already have a macro that can do 1-3, but am having a hard time thinking of a good way to do 4. My first thought was to add properties to the drawing, but then I need to have all the call outs (I dont know what their called but the \$PROPERTIES{VALUE} text used in the sheet format) for each rev and all the rev info (by, description, date, ect.). But this is the only way I can think of that will work. I'm not sure how I could identify a table using the SW API as it doesn't seem to be an object in the drawing. The only other way I can think of is to have the macro add a note at specific XY points depending of the rev but then if the drawing rev table were to change that would be a pain to re configure.