Purpose of this function module?

[Former Member]

Hi Abapers,

Please let me know the purpose of this function module.

RH_START_EXCEL_WITH_DATA.

regards,

vijay

[Former Member]

Hi Vijay,

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.

Refer the link.

Rgds,

Prakashsingh

[Former Member]

Hi vijay,

1. It will open EXCEL

with our data

which is specified in the internal table.

regards,

amit m.

[Former Member]

Hi,

<b>Taken from documentation:</b>

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.

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

[Former Member]

Hi,

It allows you to download an internal table into a spreadsheet.When calling this FM you pass the internal table, then Excel starts automatically and opens up with the data from your internal table.

Check these links for examples:

Regards,

Anjali

[Former Member]

Hi Anjali,

i have a problem with der FM "RH_START_EXCEL_WITH_DATA". After the release of our SAP-system changed to ERP2005 the FM doesn't work. After calling the FM with an filled internal table Excel starts but the spreadsheet is empty.

What can i do?

Regards

Jutta

Problem is solved. There is no more an TABLES parameter DATA_TAB, now the internal table is an exporting parameter named DATA_TABLE.

Message was edited by: Jutta Campbell

[Former Member]

Hi All,

Do you have some issues with FM RH_START_EXCEL_WITH_DATA when your Excel is 2007?

The data is either corrupted or garbled.

Thanks.

Jaime

[Former Member]

What GUI patch level do you have?

Rob

[dani_mn]

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

The function offers a number of additional features:

You can specify a minimum version for Excel required for the function module to run (parameter CHECK_VERSION). If you make no input here (SPACE), no check is carried out.

You can start Excel modal or modeless (parameter WAIT).

You can transfer data in various formats (parameter DATA_TYPE). For a list of valid data types, please refer to the function

Regards,

Wasim Ahmed

[Former Member]

If you mention the Excel sheet file path in the 'DATA_FILENAME' of the EXPORTING parameters of the FM 'RH_START_EXCEL_WITH_DATA', it will open that particular excel file.

[Former Member]

Starting Excel with Data Download and Execution of a Macro

plz rewards the points if it is helpful

[Former Member]

Hi vijay,

1. Suppose i want to show some data

DIRECTLY IN EXCEL,

from my internal table.

2. Just copy paste in new program.

(it will show data from T001 Table,

directly into excel)

3.

report abc.

*----

---

data : itab like table of t001 with header line.

select * from t001 into CORRESPONDING FIELDS OF table itab.

*----

---

CALL FUNCTION 'RH_START_EXCEL_WITH_DATA'

EXPORTING

DATA_FILENAME = '\ABCdd.XLS'

DATA_TABLE = ITAB[]

WAIT = 'X'

DELETE_FILE = 'X'

EXCEPTIONS

NO_BATCH = 1

EXCEL_NOT_INSTALLED = 2

INTERNAL_ERROR = 3

CANCELLED = 4

DOWNLOAD_ERROR = 5

NO_AUTHORITY = 6

FILE_NOT_DELETED = 7

OTHERS = 8.

regards,

amit m.