Controlling Excel with VB

[LopezS3]

Hi Guys

I am having a problem trying to write some data to Excel using VB to control the excel application through an Excel.Application object.
In fact the problem only appears when the my program is running under W98.

The problem is that the program uses Excel to export some data calculated with the the VB program, in fact a huge amount of data around 70000. When VB has write about a half of the data, sudenly Excel hangs up. I do now the reason, because this problem does not appear under W95. Has any of you experienced such a proble? help is needed desperately.

Thanks

[HDR]

Check out this post. It sounds like the same problem.

http://forums.vb-world.net/showthrea...threadid=17668

[LopezS3]

Originally posted by LopezS3
Hi Guys

I am having a problem trying to write some data to Excel using VB to control the excel application through an Excel.Application object.
In fact the problem only appears when the my program is running under W98.

The problem is that the program uses Excel to export some data calculated with the the VB program, in fact a huge amount of data around 70000. When VB has write about a half of the data, sudenly Excel hangs up. I do now the reason, because this problem does not appear under W95. Has any of you experienced such a proble? help is needed desperately.

Thanks

I have tried all those things, and I sucessfully make the program works properly in a w98, However in another machihe with the same configuration but in a network the excel still hangs. Any other source of information, Thanks