Ansicht
Dokumentation

RH_START_EXCEL_WITH_DATA - Starting Excel with Data Download and Execution of a Macro

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Data in Customer Master  
This documentation is copyright by SAP AG.

Functionality

This module enables you to transfer ASCII data (Parameter DATA_TABLE) to a front end and subsequently to start Excel. The system automatically opens the file with the data (parameter DATA_FILENAME).

You can start Excel modally or modelessly (parameter WAIT). If you start Excel modally, you can specify that the file is to be automatically deleted when Excel is closed (DELETE_FILE = 'X').
Standard path specifications can be added automatically to the file names transferred (Parameters DATA_PATH_FLAG, DATA_ENVIRONMENT, MACRO_PATH_FLAG, and MACRO_ENVIRONMENT). Refer to the function RH_COMPILE_FILENAME for a list of the index abbreviations currently supported.
In addition, when you start Excel, you can simultaneously load a macro. The name of the macro is in the parameter MACRO_NAME.

Notes

The function module cannot be run in batch. The runtime takes several seconds the first time the module is called, since a control flush must be generated.

This function module must not be used in customer programs.

Parameters

CODEPAGE
DATA_ENVIRONMENT
DATA_FILENAME
DATA_PATH_FLAG
DATA_TABLE
DELETE_FILE
MACRO_ENVIRONMENT
MACRO_FILENAME
MACRO_PATH_FLAG
WAIT

Exceptions

CANCELLED
DOWNLOAD_ERROR
EXCEL_NOT_INSTALLED
FILE_NOT_DELETED
INTERNAL_ERROR
NO_AUTHORITY
NO_BATCH

Function Group

HRBAS00OFFICE

TXBHW - Original Tax Base Amount in Local Currency   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 1644 Date: 20240523 Time: 152904     sap01-206 ( 38 ms )