Exporting dw to Excel using OLE using PB5

Exporting dw to Excel using OLE using PB5

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….


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?

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.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several