How to edit Lookup Tables using import / export macro and Excel (MEP)

I have previously described how you can Link Excel spreadsheet data into Revit (through AutoCAD).

But what if you want to semi-automate the process of editing Lookup Tables using Excel?  The blog http://www.revitmep.es/ shows you how:

We explain how to create a lookup table for the families…
The biggest impediment there is import and export these files, we use a macro in Excel to streamline these tasks.
via
Google Translate

of

Original Post

And here is a direct link to the macro-enabled Excel file:
Editor Lookup Tables.xlsm

 

1
Leave a Reply

avatar
1 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
0 Comment authors
Andrei Bejenaru Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Andrei Bejenaru
Guest

Hey Luke,
Thanks for publishing our post. 6 months ago we've started the revitmep.es blog and we encourage everyone to collaborate.

Thaks again for publishing and I hope this method helps

Cheers