Macro: Export/Import Entity Details and Attachments to Excel

This contains two macros which will import and export entity information and attachments to Excel.  The format will be

Model Name, Owner Name, Entity Name, Column Name, Datatype, Attribute Definition, Attachment1, Attachment2, ... Attachmentn

EntityDetailAndAttachmentImportExport.zip

  • I'm testing these using the Northwind Diagram (because it has attachment bindings for Privacy level with 4 possible values).  I dump it out using the export macro, no problem.  I make changes in the attachment column I want in the spreadsheet, then try to import.  Import macro finishes, but value for attachment doesn't change.  I have the diagram checked out, all objects show as such.  Please help.