I have written a Progress 4GL GUI program that automatically opens a Excel worksheet. But i get an error when the rows are more than 65000, even though i run it on Excel 2007 which has more than 1 million rows. I am told it has to do with DLL files. Which DLL am i suppose to edit and change to what?

Earlier versions of Excel are limited to smaller numbers of rows (and columns too no doubt).
There's no way around that, except to use a later version of Excel.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.