Uso de Excel «FORMS» para proporcionar el usuario final inició la función de selección de funciones:
Formar el menú Excel Ver > Barras de herramientas > Formularios. Aparecerá la barra de herramientas de formularios.
Para crear un «botón» seleccionable por el usuario, seleccione el formulario que se vea como un rectángulo gris.
Cree el botón moviendo el cursor a la ubicación deseada y trace la ubicación del botón. Siempre puede cambiar el tamaño y reposicionar el botón en una fecha posterior mediante el acceso al control de formato del objeto.
Al crear el botón, se le pedirá que identifique una macro para el objeto. La macro es el programa Excel que se ejecutará cuando se haga clic en el botón.
Las siguientes macros se utilizan normalmente en las aplicaciones BPC:
MNU_ETOOLS_REFRESH
[Same as «REFRESH WORKBOOK»]
MNU_ESUBMIT_REFRESH
[Same as «SEND AND REFRESH SCHELDULE»]
BPC Excel tiene una variedad de macros entregadas que utiliza el constructor de aplicaciones BPC. Estas macros pueden incorporarse a cualquier diseño BPC y pueden ejecutarse mediante las instrucciones.
Tenga en cuenta, aunque esta lista es sustancial, no quiero implicar que de ninguna manera es 100% completa:
| PROGRAMA |
API |
| Send and Refresh Schedule | MNU_ESUBMIT_REFRESH |
| Open My Schedule | MNU_ESUBMIT_OPENMY |
| Save My Schedule | MNU_ESUBMIT_SAVEMY |
| Open Dynamic Schedule Template | MNU_ESUBMIT_SCHEDULE |
| Open Schedule Library | MNU_ESUBMIT_OPENSTANDARD |
| Validate Submission | MNU_ESUBMIT_VALIDATE |
| Publish to Content Library | MNU_ESUBMIT_SUBMIT |
| Modify Work Status | MNU_ESUBMIT_MODIFY |
| Spread | MNU_eSUBMIT_ESPREAD |
| Trend | MNU_eSUBMIT_ETREND |
| Weight | MNU_eSUBMIT_EWEIGHT |
| Manage Dynamic Hierarchies | MNU_ESUBMIT_MANAGE_DYNAMICHIERARCHIES |
| Using Schedule’s Help | MNU_ESUBMIT_HELP |
| Open My Reports | MNU_EANALYZE_OPENMY |
| Save My Reports | MNU_EANALYZE_SAVEMY |
| Open Dynamic Report Template | MNU_EANALYZE_REPORTWIZARD |
| Open Report Library | MNU_EANALYZE_OPENSTANDARD |
| Audit Reports | MNU_EANALYZE_VIEWAUDIT |
| Using Report Help | MNU_EANALYZE_HELP |
| Open Web-Ready File from BPC Web | MNU_EPUBLISH_OPENPUBLICATION |
| Save as Web-Ready File | MNU_EPUBLISH_PUBLISHSHEET |
| Book Publication Wizard | MNU_EPUBLISH_PUBLISHBOOK_WIZARD |
| Create New Book | MNU_EPUBLISH_PUBLISHBOOK_NEW |
| Edit Book | MNU_EPUBLISH_PUBLISHBOOK_EDIT |
| Save Book | MNU_EPUBLISH_PUBLISHBOOK_SAVE |
| Save As Book | MNU_EPUBLISH_PUBLISHBOOK_SAVEAS |
| Validate Book | MNU_EPUBLISH_PUBLISHBOOK_VALIDATE |
| Offline Distribution Wizard | MNU_EPUBLISH_OFFLINE_WIZARD |
| Manage Distribution List – New | MNU_EPUBLISH_OFFLINE_NEW |
| Manage Distribution List – Edit | MNU_EPUBLISH_OFFLINE_EDIT |
| Manage Distribution List – Save | MNU_EPUBLISH_OFFLINE_SAVE |
| Manage Distribution List – Save As | MNU_EPUBLISH_OFFLINE_SAVEAS |
| Manage Distribution List – Validate | MNU_EPUBLISH_OFFLINE_VALIDATE |
| View BPC Web | MNU_EPUBLISH_VIEWeDASH |
| Publishing Help | MNU_EPUBLISH_HELP |
| Park N Go | MNU_ETOOLS_PARKNGO |
| Expand All | MNU_ETOOLS_EXPAND |
| Refresh Workbook | MNU_ETOOLS_REFRESH |
| Drill Down | MNU_ETOOLS_DRILLDOWN |
| Drilldown Back | MNU_ETOOLS_DRILLDOWN_BACK |
| Drill Down Forward | MNU_ETOOLS_DRILLDOWN_FORWARD |
| Drill Through | MNU_ETOOLS_DRILLTHROUGH |
| Select Member | MNU_ETOOLS_MEMBERSELECTOR(xxxxxxx) |
| Function Wizard | MNU_ETOOLS_FUNCTIONWIZARD |
| Refresh Dimension Members | MNU_ETOOLS_UPDATEAPPINFO |
| Data Manager | MNU_ETOOLS_DATAMANAGER |
| Workbook Options | MNU_ETOOLS_WBOPTION |
| Open Dynamic Templates | MNU_ETOOLS_OPENSTANDARD |
| Save Dynamic Templates | MNU_ETOOLS_SAVESTANDARD |
| Open Custom Menu | MNU_ETOOLS_PSMANAGER_OPEN |
| Test Current Worksheet | MNU_ETOOLS_PSMANAGER_COMPILE |
| Save Custom Menu | MNU_ETOOLS_PSMANAGER_SAVE |
| Change Application Set | MNU_ETOOLS_CHANGEAPP |
| Client Options | MNU_ETOOLS_OPTION |
| Journal | MNU_ETOOLS_JOURNAL |
| View BPC Action Pane | MNU_ETOOLS_TASKPANE |
| BPC for Office Help | MNU_ETOOLS_HELP |
| About BPC | MNU_ETOOLS_ABOUT |
| Run Package | MNU_eData_RUNPACKAGE |
| Packages Schedule Status | MNU_eData_PackageSechedules |
| View Status | MNU_eData_ViewStatus |
| Organize Package List | MNU_eData_OrganizePackage |
| Manage Team User Package Access | MNU_eData_ManageSitePackage |
| Data Preview | MNU_eData_DataPreview |
| Data Upload | MNU_eData_DataUPLoad |
| Data Download | MNU_eData_DataDownLoad |
| New Transformation File | MNU_eData_NewTransformation |
| Manage Transformation Files | MNU_eData_OpenTransformation |
| Validate and Process Transformation File | MNU_eData_SaveTransformation |
| Copy Transformation File | MNU_eData_SaveAsTransformation |
| New Conversion File | MNU_eData_NewConversionFile |
| Manage Conversion File | MNU_eData_OpenConversionFile |
| Validate and Process Conversion File | MNU_eData_SaveConversionFile |
| Copy Conversion File | MNU_eData_SaveAsConversionFile |
| Add Conversion Sheet | MNU_eData_NewConversionSheet |
| Clear Save Prompt Values | MNU_eData_ClearPromptValue |
| Data Manager Help | MNU_eData_Help |
| About Data Manager | MNU_eData_About |
| Show Member List | MNU_eData_Showmemberlis |
Medievals Trucos 