Question:
Hi,
I have three internal tables those have to be downloaded into different worksheets of an excel file. currently, my program genartes multiple-sheet excel file using OLE. I need to send the excel file to a FTP server.
Is it possible to send the file to non-sap ftp server.
Answer:
A wild guess here, might work if you can write (or arrange for) a marco in VB.
After you create the excel with multiple worksheets, (write and) run a marco which saves the file on the PC's temp folder (you can use method CL_GUI_FRONTEND_SERVICES=>GET_TEMP_DIRECTORY for this) and close the file. This was the difficult part. Once this is over, you can use *FTP* FMs to FTP the file.
Regards
Sudhir/Mohit