issues of FM EXCEL_OLE_STANDARD_DAT

250 Views

Hi experts,

Now i come across two issures while using the FM EXCEL_OLE_STANDARD_DAT.

the exect codes is as following:

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

EXPORTING

file_name = 'C:\Carl'

TABLES

data_tab = lt_data

fieldnames = lt_label

EXCEPTIONS

FILE_NOT_EXIST = 1

FILENAME_EXPECTED = 2

COMMUNICATION_ERROR = 3

OLE_OBJECT_METHOD_ERROR = 4

OLE_OBJECT_PROPERTY_ERROR = 5

INVALID_PIVOT_FIELDS = 6

DOWNLOAD_PROBLEM = 7

OTHERS = 8

.

the very issues which i facing are as following:

1 while I run the PROGRAM ,the executed Excel file is auto pened ,is it possible to generate the Carl.XLS file and with out

open the generated file? if it is possible ,hope you could gvie me your solution!

2 While I execute the PROGRAM two files are generated,one is Carl.xls,the other is Carl.dat.

is it possible to avoid to generate the second file which i don't wished! how could i realise it?

hope to receive your response!

best regards!