Flyguy

I need your help. Since you don't seem to be answering your PM's i have to ask you here. It's in regard to your excel export code and your flexgrid sort code. They both work fine in my program but when the user sorts the flexgrid and then exports it, i need it to export only the records that remain in the flexgrid. What happens right now is that it exports the whole database. This is a big problem becasue this database will grow really big quite quickly and the user will not want to export the whole database everytime.

Thanx and i hope this is possible.

Do you mean filter instead of sort.

I ask, because a sort would not leave you with less records than you started with

This was your complete PM to me:

I have a problem with the excel export code.
check it out here
http://www.visualbasicforum.com/t69369.html

Thanx


I gave you this answer in the same thread:

Ofcourse it can be done, BUT you have to code it yourself.

All functions I posted are standalone functions. They can be altered to suit your needs, but they are in no way related.

The most simple way would be to add some lines of code to the export routine to check whether the .RowHeight() <> 0 before writing the cells.


Your answer:

OK, i have been trying that, but i can't figure out where to put it.

Where should I put it?
----
Never Mind I figured it out.

Thanx for the info.


So, to what am I not replying?