Forum FlexPro – Discuss your topic!

Flexpro and Excel macro problems

Accueil > Community > Automation and VBA > Flexpro and Excel macro problems

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #12402
    Gilles QuintonGilles Quinton
    Participant

    Hi

    I try to record a Flexpro (V7) macro opening an excel workbook, making an excel datalink and then plot the data. I can easily perform it by hand but would like to automatise the operation.
    —> the macro is recorded but each time I run it, it bugs somewhere randomly between line 3 and 6. I managed however to have it working till the excel data link creation removing some lines and opening the workbook before running the macro. But this behaviour seems very weird and the graph is not plotted anyway (no crash, nothing just happen)

    “Sub Macrodatalink()

    ActiveDatabase.Selection.SelectObject “vol_116-15_MA1_ori.XLD”
    ActiveDatabase.SelectedObject.Open = True
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    Windows(“vol_116-15_MA1_ori”).Activate
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    With ActiveDatabase.ActiveObject.Add(“ExcelDataLink4”, _
    fpObjectTypeExcelDataLink)
    .YComponent = “FT!W6:AT6”
    .XComponent = “FT!W9:AT9”
    .YLineByLine = True
    .XLineByLine = True
    .Update
    End With
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    Windows(“vol_116-15_MA1_ori”).Activate
    End Sub
    PS: – my excel file is vol_116-15_MA1_ori.xls
    – the database is EMA_TEST.FPD

    Then, I would like the macro to select a specific excel sheet, select cells and perform some operations. It seems to be impossible as I did not find any way to have the macro recording any operation I made in Excel. Whatever I do I always have this code and nothing else:

    “Sub Macro1()
    Windows(“vol_116-15_MA1_ori”).Activate
    ActiveWindow.View = fpWindowViewExcel
    End Sub”

    —-> So, is it possible to have Flexpro macro working with excel worksheets?

    Thanks

    #8085
    Gilles QuintonGilles Quinton
    Participant

    Hi

    I try to record a Flexpro (V7) macro opening an excel workbook, making an excel datalink and then plot the data. I can easily perform it by hand but would like to automatise the operation.
    —> the macro is recorded but each time I run it, it bugs somewhere randomly between line 3 and 6. I managed however to have it working till the excel data link creation removing some lines and opening the workbook before running the macro. But this behaviour seems very weird and the graph is not plotted anyway (no crash, nothing just happen)

    “Sub Macrodatalink()

    ActiveDatabase.Selection.SelectObject “vol_116-15_MA1_ori.XLD”
    ActiveDatabase.SelectedObject.Open = True
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    Windows(“vol_116-15_MA1_ori”).Activate
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    With ActiveDatabase.ActiveObject.Add(“ExcelDataLink4”, _
    fpObjectTypeExcelDataLink)
    .YComponent = “FT!W6:AT6”
    .XComponent = “FT!W9:AT9”
    .YLineByLine = True
    .XLineByLine = True
    .Update
    End With
    Databases(“D:\Documents and Settings\gquinton\Mes documents\Softs\Flexpro\Projets\EMA_TEST.FPD”).Activate
    Windows(“vol_116-15_MA1_ori”).Activate
    End Sub
    PS: – my excel file is vol_116-15_MA1_ori.xls
    – the database is EMA_TEST.FPD

    Then, I would like the macro to select a specific excel sheet, select cells and perform some operations. It seems to be impossible as I did not find any way to have the macro recording any operation I made in Excel. Whatever I do I always have this code and nothing else:

    “Sub Macro1()
    Windows(“vol_116-15_MA1_ori”).Activate
    ActiveWindow.View = fpWindowViewExcel
    End Sub”

    —-> So, is it possible to have Flexpro macro working with excel worksheets?

    Thanks

    #8645
    Bernhard KantzBernhard Kantz
    Participant

    In FlexPro it’s not possible to record any operation of the Excel environment.
    But you could record the code in Excel and copy it into FlexPro. In this case you have to revise your code.

    support@weisang.com

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.