BOM to Excel 2003 problem
BOM to Excel 2003 problem
(OP)
For some reason Catia is outputing blank BOM's in excel. I can save .txt's and html's no problem, but .xls comes out empty. I am running Windows x64 and Office 2003. Is there some setting I am overlooking? Is it a 64bit incompatibility? My coworker can output a BOM into excel without any problem on his 32 bit machine. Any help will be greatly appreciated.





RE: BOM to Excel 2003 problem
Regards,
Derek
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
There are options for just this sort of scenario.
If you want service packs, your VAR is under no obligation to provide them, unless he put it in some sort of contract OR if you are on the new VAR model - which is the alternative to the old system of going through IBM for support.
Search the IBM website for "PLM support". You will need your customer number in order to be able to register for the online access.
-----------------------------------------------------------
Catia Design|Catia Design News|Catia V5 blog
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
https://w
Good luck!
Steve
Letourneau Technologies
RE: BOM to Excel 2003 problem
Attend the COE conference next month in Las Vegas. The cost is relatively low, but the amount of networking; "free" training, and Hints Tips and Techniques that you will learn will more than pay for it. It's really a weeks worth of experience packed into 3 days.
Visit www.coe.org for more information
RE: BOM to Excel 2003 problem
Regards,
Derek
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
I'm running R17 on x64. Could you be more specific?
-----------------------------------------------------------
Catia Design|Catia Design News|Catia V5 blog
RE: BOM to Excel 2003 problem
Sorry - should have said x64, SP2...
-----------------------------------------------------------
Catia Design|Catia Design News|Catia V5 blog
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
So then it's an Excel (Office) problem, and not a Catia problem?
-----------------------------------------------------------
Catia Design|Catia Design News|Catia V5 blog
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
Thanks for the update.
By the way - you can still use a Tab delimited plain text document, in place of an Excel spreadsheet.
-----------------------------------------------------------
Catia Design|Catia Design News|Catia V5 blog
RE: BOM to Excel 2003 problem
RE: BOM to Excel 2003 problem
We have the exact same issue with empty spread sheets.
We are running Catia 64bit R17 SP05 and Windows XP 64bit Service Pack 2 with Office 2003.
RE: BOM to Excel 2003 problem
Dim oRootDoc
Dim oRootProd
Dim assemblyConvertor1
Set CATIA = GetObject(, "CATIA.Application")
Set oRootDoc = CATIA.ActiveDocument
Set oRootProd = oRootDoc.Product
Set assemblyConvertor1 = oRootProd.GetItem("BillOfMaterial")
Dim arrayOfVariantOfBSTR1(11)
arrayOfVariantOfBSTR1(0) = "Part Number"
arrayOfVariantOfBSTR1(1) = "Quantity"
arrayOfVariantOfBSTR1(2) = "UM"
arrayOfVariantOfBSTR1(3) = "Material"
arrayOfVariantOfBSTR1(4) = "NumeroDeCatalogo"
arrayOfVariantOfBSTR1(5) = "ScrewsName"
arrayOfVariantOfBSTR1(6) = "ScrewsQty"
arrayOfVariantOfBSTR1(7) = "ScrewType"
arrayOfVariantOfBSTR1(8) = "DowelName"
arrayOfVariantOfBSTR1(9) = "DowelQty"
arrayOfVariantOfBSTR1(10) = "DowelType"
Dim assemblyConvertor1Variant As Object
Set assemblyConvertor1Variant = assemblyConvertor1
assemblyConvertor1Variant.SetCurrentFormat arrayOfVariantOfBSTR1
Dim NumOfProducts As Integer
Dim i As Integer
Dim oSubProd 'As product
Dim SourceFileName As String
Dim NumOfSubProducts As Integer
NumOfProducts = oRootProd.Products.count
i = 2
For i = 1 To (NumOfProducts)
Set oSubProd = oRootProd.Products.Item(i)
SourceFileName = Folder & "\" & oSubProd.Name & ".xls"
oSubProd.ExtractBOM catFileTypeHTML, SourceFileName
RE: BOM to Excel 2003 problem