Customizing Delivered Visual Basic Application Wizards
NVSUSER delivers Visual Basic Application (VBA) forms to perform functions ranging from storing information in the PeopleSoft system to creating a button to run a report. To find the VBA forms in PS/nVision, open an report layout and select
from the Excel menu bar.The VBA forms provide several examples of using Visual Basic PeopleSoft APIs to personalize PS/nVision. These features can add depth to your reporting ability.
Several VBA wizards take advantage of the PeopleSoft Open Query method to pull information from the PeopleSoft system. To use this method, you need to create a query in the PeopleSoft system.
VBA forms also pass prompt values to the queries. The following table lists the queries that PS/nVision accesses and the wizards that use the listed queries.
Query |
VBA Wizard |
---|---|
NVS_OPERATORS |
NVSUSER.xls |
NVS_PERSNL_RPTS |
NVSUSER.xls, Personal_Settings |
NVS_CATEGORY |
NVSUSER.xls, Personal_Settings |
NVS_RPT_ID |
Personal_Settings, Button Wizard |
NVS_MENU |
PSDrill |
NVS_MENU_BAR |
PSDrill |
NVS_MENU_ITEM |
PSDrill |
NVS_MENU_PANEL |
PSDrill |
NVS_MENU_PNL_KEYS |
PSDrill |