- Jason Lipman
- PowerBuilder
- Wednesday, 21 February 2018 07:48 PM UTC
PB 2017 R2, Build 1756
Hello PB Community,
I have the OLE code to paste the contents of a datawindow to an Excel spreadsheet (thank you to all the examples available online!)
I want to copy multiple datawindows into the same worksheet, but pasting always defaults to row/column 1,1.
This does NOT work..
lole_excel.ActiveWorkbook.Sheets(1).Rows(ll_totrows).Select
lole_excel.ActiveWorkbook.Sheets(1).Columns(1).Select
Is the GOTO syntax correct? But if so, does someone know the correct syntax?
Of course, if I am off-track altogether, let me hear it!
Thank you!
Jason Lipman
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.