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'
file_name = 'C:\Carl'
data_tab = lt_data
fieldnames = lt_label
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!