Results 1 to 6 of 6

Thread: Excel VBA to Revit

  1. #1
    Member
    Join Date
    2007-02
    Location
    Vancouver, CA
    Posts
    13
    Login to Give a bone
    0

    Default Excel VBA to Revit

    Has anyone ever been able to have Excel talk to Revit via VBA.

    We would like to have Excel manipulate the RVT file as a lot of our design is done through spreadsheets with VBA Macros.

    We know that Revit only talks to .NET apps, etc. but maybe there is a way for VBA to talk to VB which talks to Revit.

    Thanks,

    Mark.

  2. #2
    I could stop if I wanted to Danny Polkinhorn's Avatar
    Join Date
    2003-12
    Location
    San Francisco, CA
    Posts
    448
    Login to Give a bone
    0

    Default Re: Excel VBA to Revit

    Mark,

    Your only choice is to create a Revit app (in .NET) that reads the data in the Excel file and creates/updates the model. What limited support there used to be for ActiveX is now gone.

    Hope that helps,

  3. #3
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2015-10
    Location
    New York NY
    Posts
    1,497
    Login to Give a bone
    0

    Default Re: Excel VBA to Revit

    I had a thought the other day...just a thought.

    What if Excel writes out a comma delimited file of the data, and Revit API reads it directly via <open for input>. You could bypass the whole clumsy and slow MSOffice interface between Excel and Revit?

    Any thoughts?

  4. #4
    I could stop if I wanted to Danny Polkinhorn's Avatar
    Join Date
    2003-12
    Location
    San Francisco, CA
    Posts
    448
    Login to Give a bone
    0

    Default Re: Excel VBA to Revit

    Yes, there are certainly ways to optimize this connection, including eliminating Excel completely with a custom 'design app'. What's not possible in his scenario is driving Revit from Excel without exposing the .NET app to ActiveX. I guess that was really my point.

    Thanks,

  5. #5
    Member
    Join Date
    2007-02
    Location
    Vancouver, CA
    Posts
    13
    Login to Give a bone
    0

    Default Re: Excel VBA to Revit

    Thanks for the input Danny.

    We will try that approach. (Revit reading the .xls file and manipulating the model)

    Mark.

  6. #6
    All AUGI, all the time clog boy's Avatar
    Join Date
    2006-12
    Location
    Probably near a PC.
    Posts
    843
    Login to Give a bone
    0

    Default Re: Excel VBA to Revit

    Keep in mind tho, that an API works from within Revit. So Excel isn't talking to Revit, if I'm correct, but rather Revit is reading an excel file and is using that data. I also think this works best for data that can be manipulated through schedules.

    Bottom line, try a limited and simplified approach, and see what you can do from there. (is what I'd do if I were able to create API's for Revit)

    Keep us up to date.

Similar Threads

  1. 2012: Best Revit-Excel app?
    By Duncan Lithgow in forum Revit Architecture - General
    Replies: 2
    Last Post: 2013-01-31, 07:56 PM
  2. Excel to Revit?
    By Jun Austria in forum Revit Architecture - General
    Replies: 1
    Last Post: 2010-01-28, 11:27 AM
  3. excel in Revit?
    By paul.meco in forum Revit Architecture - General
    Replies: 3
    Last Post: 2007-04-03, 04:20 PM
  4. Excel in Revit
    By E-Key in forum Revit Architecture - General
    Replies: 1
    Last Post: 2005-05-27, 06:43 PM
  5. REVIT AND EXCEL
    By WATTSAIA in forum Revit Architecture - General
    Replies: 4
    Last Post: 2004-03-11, 04:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •