Excel 2007 & R16

[Runz]

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,

 

[DBezaire]

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

 

[Runz]

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.

 

[DBezaire]

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

 

[DBezaire]

Runz - the link for above.

http://www.coe.org/Collaboration/Di...ew/topic/forumid/6/postid/112869/Default.aspx

I have tried the various solutions in the link - with no success.

http://www.coe.org/Collaboration/Di...iew/topic/forumid/6/postid/98993/Default.aspx

Regards,
Derek

 

[MarkAF]

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