DataGrid (Grid view) Interview Question:

Why does saving to XLS instance not work sometimes?

Submitted by: Administrator

From the Toad lists.

One of my co-workers experiences a very strange problem. When he is saving the results of a query using "Save As" into Excel Instance nothing happens. There is 1 opened Excel and it stays empty. All other "save as" option work fine (including saving into Xls File). What could be the problem?

John Dorlon replied :

*
Close excel.
*
Look in task manager.
*
If you still see excel running, kill it.

It seems that Excel gets confused as to whether it is running once or not and the hidden instance of Excel is causing the problem as it is most likely receiving the saved data. (explanation courtesy of Norm and it might even be right! LOL)
How do I name the tabs when I run a script?
Submitted by: Administrator