PowerBuilder - OLE problems: excel attributes (same versions OS/PB/Excel)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

OLE problems: excel attributes (same versions OS/PB/Excel)

Jano

2004-03-27, 12:22 am

Hi everyone,

I have a PB 7.0 app which generates an Excel sheet using OLE. This has
worked fine for several months, but recently in a new batch of
computers the program crashes at one line like this:

loo_excel.cells[base + row, column].NumberFormat = "@"

There are aplenty of other accesses, setting cell values, borders,
etc, it's just that assignation the one which fail -- always.

The computers are apparently identical: same XP version, same PB7.0
patch, same Excel version. But it just won't work.

I've tried to use the OLE explorer in the object browser of PB, but it
don't allow to show the properties of the Cells oleobject...

Do you know of any reason causing that line to fail? Could someone
suggest some tool to explore the excel OLE properties in the failing
computers?

Thanks in advance,

Alex.

Sponsored Links