devxlogo

Exporting dw to Excel using OLE using PB5

Exporting dw to Excel using OLE using PB5

Question:
I’m trying to export a report to Excel with OLE automation. I’m using PB 5.0.2 and Excel 97. I’ve seen countless examples on how to do this (in fact, I tried yours too!), but I keep getting an error when I try to call an Excel method. For example:

…..previous code to create the ole object and resolve the ole sheet variable, fill the cells with appropriate data (which works fine!) and then….

lole_sheet.Range(“A1:M3”).Select

This produces an error saying “Error calling external object function Range at line…”I’m also calling the Columns( ) method later and I’m getting a similar runtime error. What am I doing wrong?

Answer:
The problem you have is the version of Powerbuilder you are using. PB5 did not have the best OLE Automation support, and a lot of commands do not work properly. With PB6, Sybase hired a guy who had a much better understanding of OLE, and he has fixed many of the problems. I’m afraid the answer is to upgrade to PB6.

See also  Monetize TikTok For Your Business
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist