dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: COM/DCOM/COM+
Expertise: Beginner
Feb 18, 1999

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date