visual basic 6 and excel problem

Dear forum,

I need some help with the visual basic 6. I made a small application and I face a strange for me problem. The programs it passes same data files into excel. After that it made several checks and if it finds problem note them by changing the row color. The problem I must deal with is that when I try to call the sorting function from excel I receive an error 1004, which means that the function it could not be called. Could someone inform me where the mistake it and how I could fix it, what I am doing wrong.
I upload the code and a data file in order to understand the problem better.
Thanks in advance for your time.

Hi

Could u please post your code, so that it will be helpful for us to identify the error.

Your zip file contains an exe only.

That is useless to us for two reasons.

2. No one is going to download an exe file, regardless of who posts it. You can never be sure what it is going to do.

1. How can we offer suggestions on fixing code we can't see. If you want assistance, please post the code you are using. At the very least, remove your current attachment and reattach a zip file with the source code in it.

Oh i am sorry.
I upload the source code.

VB6 to Excel...check link below

Zip attachment in your first post removed because uploading executables is not allowed in efforts to protect our members.