Ask and answer engineering questions

Learn from millions of experts

Feed

COMO PUEDO SACAR CENTRO DE COSTOS $ A UN ENSAMBLE EN ILOGIC CON EXCEL?

By Oscar Augusto Lara on 03 Dec 15:29 1 answer 0 comments

AUTODESK INVENTOR "ILOGIC"

1 answer

  • EDWARD CALDERON
    EDWARD CALDERON 5 months ago

    Lo puedes hacer con las funciones GoExcel, este es un codigo de muestra:

    'iProperties.Value("Project", "Part Number")=ThisDoc.FileName(False) 'without extension

    MultiValue.List("TIPO") = GoExcel.CellValues("3rd Party:TORNILLERIA.xlsx","TOR. HEX. G2 G5 G8","A2", "A1200")
    ' copiar en la carpeta de templates EL ARCHIVO DE EXCEL
    GoExcel.FindRow("3rd Party:TORNILLERIA.xlsx","TOR. HEX. G2 G5 G8", "TIPO", "=", TIPO)
    iProperties.Value("Project", "Description") = GoExcel.CurrentRowValue("TIPO")
    GD = GoExcel.CurrentRowValue("GD")
    GEL = GoExcel.CurrentRowValue("GEL")
    NLG = GoExcel.CurrentRowValue("NLG")
    SD = GoExcel.CurrentRowValue("SD")
    GAL = GoExcel.CurrentRowValue("GAL")
    BDM = GoExcel.CurrentRowValue("BDM")
    SD2 = GoExcel.CurrentRowValue("SD2")
    SW = GoExcel.CurrentRowValue("SW")
    KOH = GoExcel.CurrentRowValue("KOH")
    SW0 = GoExcel.CurrentRowValue("SW0")
    ANG1 = GoExcel.CurrentRowValue("ANG1")
    SPD = GoExcel.CurrentRowValue("SPD")
    GUL = GoExcel.CurrentRowValue("GUL")
    R = GoExcel.CurrentRowValue("R")
    ROSCA = GoExcel.CurrentRowValue("ROSCA")
    CALIDAD_MATERIAL = GoExcel.CurrentRowValue("MATERIAL")
    iProperties.Material= CALIDAD_MATERIAL
    iProperties.Value("Custom", "ERP ID")= GoExcel.CurrentRowValue("ERP ID")
    Feature.ThreadDesignation("Thread") = GoExcel.CurrentRowValue("DESIGNATION")
    iProperties.Value("Project", "Stock Number")=" "
    iProperties.Value("Project", "Part Number")=iProperties.Value("Custom", "ERP ID")

    InventorVb.DocumentUpdate()

Add your answer to: "COMO PUEDO SACAR CENTRO DE COSTOS $ A UN ENSAMBLE EN ILOGIC CON EXCEL?"

Save Cancel