PDA

View Full Version : Floating Status



gld1881
10-28-2015, 07:08 AM
How to export floating status by using VertexFX BO API. Using the VertexFX BO API how to read it from the backoffice and export it in excel sheet.

Hassan-HS
10-29-2015, 06:32 AM
Hi gld :)

All what you have to do for start receiving the API floating status events or to be able using its methods, are to reference the {VertexFX Backoffice API} Dlls to the Excel VBA project, then define Object of type CVertexFXBOAPI class, after that call the following two methods:


Object.SetLoginInfo (http://www.hybrid-solutions.com/support/index.php?/Knowledgebase/Article/View/1978)


Object.Login (http://www.hybrid-solutions.com/support/index.php?/Knowledgebase/Article/View/1979)

let me know if you need any assistance.

Hassan-HS
11-09-2015, 12:08 PM
Hello Sir,

Please check the attachment to get a small sample developed using Excel VBA that show you the floating status.

Note: You must install BOAPI 10.2.4 before run the VBA script.

How to run the VBA script on Excel?



Click the "Developer" tab at the top of the screen. If you don't see a "Developer" tab, click "File" instead and choose "Options" from the menu that appears. Click on "Customize Ribbon" from the list on the left side of the window, then click the empty box next to "Developer" on the right side of the window. Click "OK" and you will now see the "Developer" tab.
Click the "Visual Basic" button on the left side of the ribbon, located within the "Code" area of the ribbon. A small window labeled "Macro" will appear.


Press F5