-
FlexPro
- At a Glance
- Features & Options
- Applications
- All Advantages
- What’s New in FlexPro 2021
- Try FlexPro For Free
- FlexPro View OEM Freeware
- Buying Guide
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
- Products
- News
- Support
- Company
- Contact
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
Flexpro and Excel macro problems
Home > Community > Automation and VBA > Flexpro and Excel macro problems
- This topic has 2 replies, 2 voices, and was last updated 17 years ago by Gilles Quinton.
-
AuthorPosts
-
October 5, 2007 at 2:53 am #12402Gilles QuintonParticipant
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.FPDThen, 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
October 5, 2007 at 2:53 am #8085Gilles QuintonParticipantHi
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.FPDThen, 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
October 5, 2007 at 9:27 pm #8645Bernhard KantzParticipantIn 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. -
AuthorPosts
- You must be logged in to reply to this topic.