Ansicht
Dokumentation

FTBU_START_EXCEL - Start Excel, Download Data, and Execute Macro

BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Functionality

This module enables you to transfer data (parameter DATA_TAB) to a frontend and then to start Excel. The system automatically opens the file containing the data (parameter DATA_NAME).

This function offers a range of additional options:
You can state the minimum version that Excel has to have for this function module to work (parameter CHECK_VERSION). If you do not enter anything here (that is SPACE), then the system does not carry out a check.
You can start Excel modally or amodally (parameter WAIT).
You can transfer data in various different formats (parameter DATA_TYPE). For a list of valid data types, see Function WS_DOWNLOAD.
You can automatically add standard path information to the transferred file names (parameter DATA_PATH_FLAG and MACRO_PATH_FLAG). For a list of folder codes that are currently supported, see Function RH_COMPILE_FILENAME.
You can also have the system load a macro as soon as it starts Excel. The name of this macro is stored in parameter MACRO_NAME.
If you do not want to or are not able to rely on Excel being correctly installed at the frontend, you can stop the system checking the installation with the parameter FORCE_START = X. In this case if Excel is not correctly installed, the system tries to start the program EXCEL.EXE directly. For this to be successful, it has to be in the search path.

Notes

The function module assumes that all versions of Excel prior to 5.0 are version 4, as the system cannot recognize these versions.

The function module is not executable in batch.
The first call takes for several seconds.

This function module internally uses the function RH_READ_EXCEL_PATH. We recommend that you read the notes for this function module.

Further information

Parameters

CHECK_VERSION
DATA_BIN_FILE_SIZE
DATA_NAME
DATA_PATH_FLAG
DATA_TAB
DATA_TYPE
FORCE_START
MACRO_NAME
MACRO_PATH_FLAG
WAIT
WINID

Exceptions

CANCELLED
DOWNLOAD_ERROR
EXCEL_NOT_INSTALLED
INTERNAL_ERROR
INVALID_TYPE
NO_BATCH
WRONG_VERSION

Function Group

FTBU_CONV

ABAP Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2517 Date: 20240523 Time: 092220     sap01-206 ( 56 ms )