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

Resolved Oleobject NOT work in the NEW PB (Beta)

  1. Issue
0
Votes
Undo
  1. Luis Pesaressi
    Luis Pesaressi
  2. Beta Testing
  3. Saturday, 3 October 2020 12:46 PM UTC

HI,  I try the PB 2019 R3 Build 2556 Runtime 19.2.0.2556

before install this version this code work

oleobject loo_excel
loo_excel = create oleobject
ll_rc=loo_excel.connecttonewobject("excel.application")
loo_excel.visible=false
//
loo_excel.workbooks.open(st_3.text)
//
loo_excel.activecell.currentregion.select()
loo_excel.selection.copy()
dw_1.importclipboard(2)
clipboard("")
loo_excel.Application.Activeworkbook.close(false)
loo_excel.Application.Quit()
loo_excel.disconnectobject()
destroy loo_excel

 

Somebody know what is the NEW change that make this code not work, because before with the PB2019 R2  this code work

Thanks 

Luis

Missing shared folder in pb 2019 r3 beta ?
TXText Control Version
Responses (4)
Luis Pesaressi
Luis Pesaressi Accepted Answer Pending Moderation
  1. Tuesday, 6 October 2020 20:39 PM UTC
  2. Beta Testing
  3. # 1

HI

Not error just Not work.....any message, in debugger just past over this code and not show any error message

 

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Saturday, 3 October 2020 16:02 PM UTC
  2. Beta Testing
  3. # 2

use ole with excel works fine for me, but i'm not using the clipboard method to load data.

 

what exactly do you mean it doesn't work?

are you getting an error? 

why do you import starting at the 2nd row: dw_1.importclipboard(2)?

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Saturday, 3 October 2020 15:04 PM UTC
  2. Beta Testing
  3. # 3

fwiw, in a quick test, it worked for me.  also used excel

build 2556

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Saturday, 3 October 2020 14:12 PM UTC
  2. Beta Testing
  3. # 4

Please open support ticket and provide test case.  This might be a beta bug since the same code worked before.

Comment
Luis Pesaressi
  1. Luis Pesaressi
  2. Saturday, 3 October 2020 15:37 PM UTC
Thanks

Now I put the problem in support ticket



Luis
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.