We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

thussain
thussain asked
on
Medium Priority
283 Views
Last Modified: 2010-05-03
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"
Comment
Watch Question

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

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

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

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.