Excel Export VBA append to exisiting sheet

[Ruffy85]

Good Morning Ladies and Gentleman,

we are using a VBA Makro to Export our Drawing Partlist It works ok. But i will improve that one.

Can i ask if its possible to export a bomlist to an exisiting File? The new Bomlist should insert as a new Table?

I think the pnly way is to create a new File and copy than the table 1 into the other sheet isnt it?

Thanks

[HermJan.Otterman]

Hello Ruffy85,

this is from the inventor help:

Public Sub BOMExport()
    ' Set a reference to the assembly document.
    ' This assumes an assembly document is active.
    Dim oDoc As AssemblyDocument
    Set oDoc = ThisApplication.ActiveDocument

    ' Set a reference to the BOM
    Dim oBOM As BOM
    Set oBOM = oDoc.ComponentDefinition.BOM
    
    ' Set the structured view to 'all levels'
    oBOM.StructuredViewFirstLevelOnly = False

    ' Make sure that the structured view is enabled.
    oBOM.StructuredViewEnabled = True

    ' Set a reference to the "Structured" BOMView
    Dim oStructuredBOMView As BOMView
    Set oStructuredBOMView = oBOM.BOMViews.Item("Structured")
    
    ' Export the BOM view to an Excel file
    oStructuredBOMView.Export "C:\temp\BOM-StructuredAllLevels.xls", kMicrosoftExcelFormat
  
    ' Make sure that the parts only view is enabled.
    oBOM.PartsOnlyViewEnabled = True

    ' Set a reference to the "Parts Only" BOMView
    Dim oPartsOnlyBOMView As BOMView
    Set oPartsOnlyBOMView = oBOM.BOMViews.Item("Parts Only")

    ' Export the BOM view to an Excel file
    oPartsOnlyBOMView.Export "C:\temp\BOM-PartsOnly.xls", kMicrosoftExcelFormat
End Sub

[MechMachineMan]

I would play around the the Drawing's PartsList Export functionality. Seems to have a couple more options for exporting that the BOM export does.

If you can't get that to work, then yes, you will be stuck with manipulating excel files and moving data by interfacing with the excel API.

[Ruffy85]

Thanks for the answers,

thats what i thought.

Anyway thx