I have created a program that calculates some values then opens Excell and exports those values in a worksheet . However , sometimes when the Excell window appears , instead of showing the shells , nothing is vizible - except the program bar that is shown at the top of the screen . When it first happened I thought that Excell crushed , but then I observed that if I try to close the program ( by pressing the "X" button in the upper right corner ) it asks me if I want to save the file ( though as I said before , nothing is shown in the screen ) . If I save the file I can find it on my hard disk , but the problem is that when I double click it in order to open it , once Excell starts , I once again can't see anything . Then , one day i did something different : I saved the weird file as described above , but instead of opening it by double clicking it , I first opend Excell and then using the open command ( from the menu line ) i found and opened the file . The result was to see perfectly the data written in the worksheet . Personally I don't think this is a solution , thus does anyone knows what is going wrong , in order to correct the problem ?

Hi,
Did you try Shift + F9 Keys to force the sheet to recalculate.  

____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Do you have a example of the file you could send on the forum?

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.

OK , tommorow I am going to try the Shift + F9 tip and I will also send a copy of such a strange file . Sorry for not answering .

I finally found out what was wrong ! It's very interesting !
It may took me a year ( that damned army got in the miidle) but I finally did it !
You see , it seems that some times Excel can get stucked if it's given alot of work to do . Let me remind you that I used Excel only to print in it the results of the calculations done by my program . I ran my program , gave it the initial data , press the calculate button   and then used to bring up Excel in order to print the calculated data  by using :

ExcelApplication.Visible = True

The problem is ( or at least I think so ) that since it was first forced to print the results instead of firstly shown itshelf , made it stuck somewhere on its way .
So here'e what I did : I simply moved the above line at the begining of the top (immediatelly after I defined an Excel application) and only then asked it to print the results .
The result was amezing ! Not only it worked , but I also had the oportunity to watch as it filled up its cells ! The view of the the vertical scrolling bar being srinked was so funny . Now I can run my program for a building with even more than 20 floors without being afraid of not being able to see the results .

[Edited by iliekater on 03-09-2006 at 12:50 PM GMT]