See the top rated post in this thread. Click here

Results 1 to 9 of 9

Thread: Revit to Excel Control

  1. #1
    All AUGI, all the time Elmo's Avatar
    Join Date
    2005-04
    Location
    South Africa
    Posts
    959
    Login to Give a bone
    2

    Default Revit to Excel Control

    Not sure if this is good enough to put here but I had to do this for a client recently. Tell if it need a little improvement.
    Attached Files Attached Files

  2. #2
    I could stop if I wanted to
    Join Date
    2003-03
    Location
    Reno, Nv.
    Posts
    277
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Good one. Nice and clean. Thanks.

  3. #3
    All AUGI, all the time tc3dcad60731's Avatar
    Join Date
    2003-10
    Location
    Charleston, SC
    Posts
    575
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Just spent the better part of the day figuring out how to export this data and then import into UDA for a contractor. This was very useful!

    As for step #3 it is BEST if you leave these settings. You will get some weird things if you start messing with that.

  4. #4
    All AUGI, all the time Elmo's Avatar
    Join Date
    2005-04
    Location
    South Africa
    Posts
    959
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Only a pleasure. Yeah I know about step 3 but then again I felt that maybe someone will actually figure out how to effectively implement step 3.

  5. #5
    AUGI Addict DaveP's Avatar
    Join Date
    2002-12
    Location
    St Paul, MN
    Posts
    1,569
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Thanks for the tutorial. This should save a lot of time.

    I'm not able to get the update to happen, though. Maybe it's because I'm not too good at Excel.

    Where do I save these files? Do I need to save the .TXT after I import it? Does the .xls need to be in a separate file, or does it have to be in a different worksheet in the same file as the .txt?

    Thanks again

  6. #6
    AUGI Addict DaveP's Avatar
    Join Date
    2002-12
    Location
    St Paul, MN
    Posts
    1,569
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Ahah!

    We're using Office 2007 & it looks like Microsoft is protecting us from ourselves again.

    I hadn't notice that there was a Security Warning at the top of the Window saying:
    Security Warning "Automatic updates of links has been disabled"
    I had to first Enable the update. Excel still didn't like that.
    Then I had to:
    • Open the txt file
    • Go back to the xls
    • Click on the Data tab
    • Click on Edit Links
    • Select the txt file
    • Click on Update Values.
    Thanks, Microsoft, for protecting me from my own content in 7 easy steps
    Maybe there's a easier way.
    At least it didn't ask my "Accept or Deny?" (I'm still in XP)

  7. #7
    All AUGI, all the time Elmo's Avatar
    Join Date
    2005-04
    Location
    South Africa
    Posts
    959
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    I can see how that can be very frustrating. Personally still prefer to use 2003 and XP pro.

  8. #8
    I could stop if I wanted to Mike Hardy-Brown's Avatar
    Join Date
    2004-09
    Location
    Melbourne, Australia
    Posts
    282
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Nice Clint,

    How 'bout you starting a blog?

  9. #9
    All AUGI, all the time Elmo's Avatar
    Join Date
    2005-04
    Location
    South Africa
    Posts
    959
    Login to Give a bone
    0

    Default Re: Revit to Excel Control

    Why would I want to do that? You and Shuan do a fantastic work on your blogs at the moment and the only real issues I could cover family related. It wouldn't be worth it since families are pretty straight forward.

Similar Threads

  1. Using MS Excel to control an objects parameters?
    By mike406689 in forum Revit Architecture - General
    Replies: 1
    Last Post: 2012-05-23, 12:13 AM
  2. Using Excel to create + control Revit Arch geometry?
    By nmiller.220753 in forum Revit Architecture - General
    Replies: 1
    Last Post: 2009-12-17, 11:17 AM
  3. Using Excel to create / control Layer Standards
    By jparker70 in forum AutoCAD Customization
    Replies: 3
    Last Post: 2007-02-19, 09:26 PM
  4. Excel in Revit
    By E-Key in forum Revit Architecture - General
    Replies: 1
    Last Post: 2005-05-27, 06:43 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
  •