How do I connect to smartview using VBA?

How do I connect to smartview using VBA?

In this topic, you declare all VBA functions by importing the smartview. bas file….Importing the Resources File

1. In Excel, select Tools > Macro > Visual Basic Editor.
2. Select File > Import File.
3. Select c:\Hyperion\SmartView\Bin\smartview. bas, and click Open to import the file.

How do I import smartview Bas?

Select Tools > Macro > Visual Basic Editor to display the Visual Basic Editor. In the Visual Basic Editor, select File > Import File. In Import File, select smartview. bas in \SmartView\bin to declare all functions or just the function you plan to use.

What is smartview in Excel?

Smart View is an excel interface that connects with Hyperion Planning and Essbase to allow users to perform ad hoc analysis and reporting, input data instead of the web-based forms, and view Financial Reporting (FR) reports. Windows Users Mac Users.

How do you write macros?

Record a macro On the Developer tab, click Record Macro. Optionally, enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording.

How do I add SmartView to excel?

1. Click on Smart View in the Disabled Items panel.
2. Click on Enable.
3. Go back to File > Options > Add-Ins.
4. Select Com Add-Ins in the Manage drop-down list.
5. Select Go.
6. In the COM Add-Ins pop-up, select Oracle Smart View for Office.
7. Click OK.
8. Close Excel.

Is SmartView an Oracle product?

Oracle Smart View for Office (Smart View) provides a common Microsoft Office interface designed specifically for Oracle’s Enterprise Performance Management (EPM) and Business Intelligence (BI). Learn about Oracle’s broad selection of application solutions.

Where can I find Smart View in VBA?

Step 5 – We are going to use 2 SmartView functions for our macros, before you can use the VBA functions; you need to import them into your workbook. To do this just import the Smart View.bas file into the project in the VBA editor, by default you can find this file in the C:\\Oracle\\Smart View\\bin directory.

How to import VBA functions in smartview.bas?

Select c:\\oracle\\SmartView\\Bin\\smartview.bas, and click Open to import the file. This file contains all Smart View VBA functions. By importing it, you are declaring all functions ready for use. You can also declare only those functions that you will use by deleting unused functions in the .BAS file.

Where can I find Oracle Smart View for office?

Information about Oracle Smart View for Office VBA functions is available in the Oracle Smart View for Office Developer’s Guide. This guide is available in the Oracle Help Center. To open this library, from the Smart View ribbon, click the arrow next to Help and then Documentation,

How to close Smart View Panel in Excel?

1. In Excel, select the Smart View tab, and click Open > Smart View Panel. The Smart View panel is displayed. 2. If any connections are active, select the active connection, and click Disconnect to close it. Click X to close the Smart View panel. 3. 4. On the Developer tab, click Insert, and select the Button icon. 5.