×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel 2007 & R16

Excel 2007 & R16

Excel 2007 & R16

(OP)
I am running R16 and recently upgraded to excel 2007.
Is it possible to export a Catia R16 bill of material to excel 2007?  I keep getting an error.

Secondly, I would like to create a document that list part weights of an assembly.  I would like to link that document to the part models...is this possible?

Thanks,

RE: Excel 2007 & R16

1)What error, is your OS 64bit?
2)I create a parameter (Type=mass) in the property page of the part.  I create a formula like this smartVolume(PartBody )*Density  

Density I pull from a design table common to all flexible parts.  Now the weights are available to the BOM.

Regards,
Derek

RE: Excel 2007 & R16

(OP)
These are the errors I get while trying to do a "save as" from the assembly model Bill of Material.

"The file you are trying to open, spreadsheet.xls, is a different format than specified by the file extension.  Verify that the file is not corrupted and is from a trusted source before opening the file.  Do you want to open the file now?"

It saves a file to the desinated folder, but the file is empty and I get the same message as shown above when I try to open the file.

Could you give me a little more detail on the linked weight application.  The document that is created, is it linked and does it update when a part weight has changed?

Thanks Derek for the reply.

RE: Excel 2007 & R16

Runz - you are on a 64bit machine, all my 32bits work fine.  I have the same problem with my Dell 690s running R16-SP7/R17-SP6  I am told from the COE forum to rollback my XP SP2 level to XP SP1.  I am working on a very hot project to sacrifice my machine to a rollback.

You generate the BOM in ASD and a weight column appears.  There is no links between weight and final output .xls file.  If you modify the Partbody the weight will update in Catia at the part properties page.
This process works for my application, what do you need to do with it?

Regards,
Derek

RE: Excel 2007 & R16

Regarding the Excel 2007 issue, I have had no luck with any of the fixes suggested in the forums, and don't think that uninstalling XP-Service Pack 2 is an option. I am using V5R16-SP4 on Windows XP-PRO 32-bit. Design tables and OLE tables in drawings still work fine, just not the BOM.

The best work-around I have found is to save the BOM as an HTML file, then open the HTML file in Excel. Take all the data and Copy > Paste Special > Values into a new file or worksheet > Save as xls. It's an extra step, but everything shows up in the right format and arrangement.

Cheers,
Mark

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources