Export to Excel problem

[Petrus Vorster]

Hi
I am having problems understanding how the Powerbasic com browser works. In the PB10 folder there are some examples on how to export a few columns of info to Excel.
It uses the EXCEL.INC file.
Somehow I cannot get Firefly to read it. Regardless of where I place it I always get the same error "Unable to find/not accessible".
The example seems easy enough and works fine if you compile it straight from PB10, but as part of my FF project I want to write a simple module function to export any listview to Excel.
I searched all over this forum on how to do this, but I could not find any on this.
Sorry, I am taking a bit long to grasp this Com thing...

Thanks for the patience!

[Petrus Vorster]

Ok, some progress.
I used the Typlib browser from JoseRoca and it created an Excel.inc that can be included.
Now just to figure out how to get that listview-to-excel sheet function going!

Hope im on the right track here!

[Petrus Vorster]

Ok, no progress. HELP....

[Petrus Vorster]

Solved! Thanks to Paul.
I created a Module function that will export any listview to Excel.
It even sets the Excell columns to the same sizes as the listview and opens the file afterwards.
Thanks all!