{"id":45242,"date":"2020-02-03T13:13:39","date_gmt":"2020-02-03T05:13:39","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/?page_id=45242"},"modified":"2024-07-05T12:39:01","modified_gmt":"2024-07-05T04:39:01","slug":"submitting-values-to-explorer","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/xla\/submitting-values-to-explorer\/","title":{"rendered":"Submitting Values to Explorer"},"content":{"rendered":"\n

IFS OI Excel Add-in provides a macro function that you can use to submit entity values to IFS OI Explorer for storage. This is typically done by embedding a button in a worksheet.<\/p>\n

The following example describes how to add a button to a worksheet and use the BFPut function to submit values to IFS OI Explorer when the button is clicked.<\/p>\n

1. Open a blank workbook in Excel, with a default worksheet name of Sheet1.<\/p>\n

2. Make sure the Developer <\/strong>tab is displayed in the ribbon toolbar (turned off by default):<\/p>\n

    \n
  1. Click the File<\/strong> tab, and select Options<\/strong>.<\/li>\n
  2. Click Customize Ribbon<\/strong>.<\/li>\n
  3. In the list on the right, select the Developer<\/strong> check box.<\/li>\n
  4. Click OK<\/strong>.<\/li>\n<\/ol>\n

    <\/p>\n

    3. Click the Developer <\/strong>tab on the ribbon.<\/p>\n

    4. Add a form button to the sheet:<\/p>\n

    a. On the Developer tab, click the Insert button and select the Button <\/strong>Form Control.<\/p>\n

    <\/p>\n

    b. Drag a rectangular area on the sheet where you want the button.<\/p>\n

    An Assign Macro<\/strong> window appears.<\/p>\n

     <\/p>\n

    5. To add some new VB macro code (which executes when the command button is clicked), click New<\/strong> in the Assign Macro window.<\/p>\n

    The Assign Macro window appears.<\/p>\n

    <\/p>\n

    6. Type a name for the macro, click in the white box, and then click New<\/strong>.<\/p>\n

    <\/p>\n

    Visual Basic opens.<\/p>\n

    7. Enter the following code:<\/p>\n

    Sub MacroName()
    \n Application.Run \"BFPut\", Sheet1.Cells(1, 1), Sheet1.Cells(1, 2), Sheet1.Cells(1, 3)
    \nEnd Sub<\/code><\/p>\n

    <\/p>\n

    8. Close the VB Macro Editor window.<\/p>\n

    You are returned to the Excel worksheet, and the button will now be labelled.<\/p>\n

    <\/p>\n

    9. Make sure that in your worksheet, you have entered the following cell data:<\/p>\n