Problem facing in XL after exporting data from VB to XL.

After exporting data to XL from VB. If I close XL then no error appears, but if I close the workbook window error appears "This program has performed an illegal operation and will be shut down"
thussainAsked:
Who is Participating?
 
web_crusherConnect With a Mentor Commented:
you probebly using access and excel not from the same version - excel 5 and access 2 are working fine - to use excel highe you'll have to get excel 7.0 !

there are a few runtime dll's that are needed and conficting between them - use excel 7.0 at least - my suggestion - aviod using access 97 - its still has many faults like every microsoft new software!
0
 
redbaron082997Commented:
it appears that you have a corrupt file. If you would like to send a freshly exported file (one that you have not opened yet) to me I will checkit out
mailto:redbaron@flash.net

0
 
thussainAuthor Commented:
Thanks ! I have solved the problem by changing my code in VB...

Before I was making excel workbook visible after exporting all the data to excel.Now I am making excel workbook visible before exporting of data to excel.

The above change has sorted my problem.

Regards,
Tasaduq Hussain

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.