Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved OLE Excel: GOTO row/column

  1. Issue
0
Votes
Undo
  1. Jason Lipman
    Jason Lipman
  2. PowerBuilder
  3. Wednesday, 21 February 2018 19: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

 

  1. Build
  2. Excel
  3. OLE
PBD function in Appeon WEB
More Git Issues (not commiting and how to exclude ...
Accepted Answer
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 22 February 2018 06:46 AM UTC
  2. PowerBuilder
  3. # Permalink

Your code first selects a whole row, than a whole column. But in sum it doesn't select a single cell.

Use

lole_excel.ActiveWorkbook.Sheets(1).Cells(ll_totrows, 1).Select

to select a single cell.

 

Comment
Jason Lipman
  1. Jason Lipman
  2. Thursday, 22 February 2018 14:31 PM UTC
Thank you, René. That works! - Jason

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.