Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from Sanjeev6 on May 1 at 10:01 AM Hi Experts,
I have created an excel sheet using ole2incl. Here is the snippet of the program
create object gobj_excel 'EXCEL.APPLICATION'.
Set Property of gobj_excel 'Visible' = 1.
call method of gobj_excel 'workbooks' = gobj_workbook.
call method of gobj_excel 'worksheets' = gobj_sheet.
.....
.....
call method of gobj_sheet 'SaveAs'
Exporting
#1 = <lv_destName>
#2 = 1 .
In the <lv_destname> i need to use the location specified in AL11 . So i have wrote the code
SELECT SINGLE dirname INTO lv_dir_param FROM user_dir WHERE aliass = 'ABC'.
after the execution of above statement i get the value lv_dir_param = /ABC/XYZ .
I concatenate time stamp into the lv_destname
CONCATENATE lv_dir_param '/' sy-datum '.xls' into lv_destname and try to use it .
It does not save.
Please help me out on this. I have been trying to solve this thing for days.
I was told that I need to use DATASET in order to read or write in UNIX environment. How can I use DATASET without having saved the excel sheet, I don't have the values of the excel sheet in any internal table.
Any suggestions is greatly appreciated.
Thank You
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
