- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello Community,
I really need your help!
I have an iLogic script which import a structured BOM and now I want to add a function/condition to to read the categories (mentioned below in the screenshot) in order to not consider all the parts/BOMs under a purchasing component.
I don´t know exactly since I am new in dealing with iLogic scripts but I assume it should be somewhere in this block:
oBOM.StructuredViewFirstLevelOnly = False
oBOM.StructuredViewEnabled = True
oBOM.StructuredViewDelimiter = "."
Dim oStructuredBOMView As BOMView
oStructuredBOMView = oBOM.BOMViews.Item("Structured")
oStructuredBOMView.Export (oFilePath & ".xls", kMicrosoftExcelFormat)
myXLS_File = oFilePath & ".xls"
myName= ThisApplication.GeneralOptions.UserName
excelApp = CreateObject("Excel.Application")
excelApp.Visible = False
excelApp.DisplayAlerts = False
If Dir(myXLS_File) <> "" Then
excelWorkbook = excelApp.Workbooks.Open(myXLS_File)
excelSheet = excelWorkbook.Worksheets(1).activate
Else
excelWorkbook = excelApp.Workbooks.Add
End If
I really appreciate your help and thank you in advance 🙂
Solved! Go to Solution.