Powerbuilder, OLE object, Excel, problem in copy and paste

Former Member — Sun, 05 Sep 2021 13:10:25 GMT

Hi All,

I found that if something is copied in clipboard outside of the program while below program is running between "copy" and "paste", then the "something" is pasted in the final output file which is not correct.

Is there any way to avoid it? Using a shared clipboard at the same time is the problem here. but I can't find solution.

Please advise. Thank you in advance.

// Combine Sheets into one excel file

FOR li_n = 1 TO 8

lole_TempWorkBook = lole_excel.WorkBooks.Open(is_currDirectory+as_filename_tab[li_n]) lole_TempWorkBook.WorkSheets(1).Cells.Select

lole_excel.CutCopyMode = False

lole_TempWorkBook.WorkSheets(1).Cells.Copy <=========================

lole_MainWorkBook.Activate

lole_sheet = lole_MainWorkBook.WorkSheets(li_n)

lole_sheet.Name = ls_tabname[li_n]

lole_sheet.Paste <=========================

//lole_sheet.Cells.EntireColumn.AutoFit

lole_excel.CutCopyMode = False

lole_TempWorkBook.Close(False)

Re: Powerbuilder, OLE object, Excel, problem in copy and paste

former_member751591 — Sun, 05 Sep 2021 13:14:09 GMT

Welcome to the SAP Community! We wanted to give you the opportunity to take the tutorial to get started in SAP Community, as it provides tips for preparing questions that draw responses from our members.

Additionally, by adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile using Profile Tutorial

Thank you!

Question Re: Powerbuilder, OLE object, Excel, problem in copy and paste in Technology Q&A

Powerbuilder, OLE object, Excel, problem in copy and paste

Re: Powerbuilder, OLE object, Excel, problem in copy and paste