I don't know where to put this question.
I have a problem in excel. Basically, I want to write data in my excel template from my sql server database. The problem is some cells in the excel has some validation where i can only input data that is exist to the pre-defined data in the cell( i dont know how to call this but it simply pop up when i select that particular cell and will show me the data on it). if the data i inputted not exist then the error will pop up. I only want that pop up error to no be displayed and will continue the process. Currently the system works fine except that i need to press the OK button in the pop up error just to proceed. I am building web application using vs 2005.
Can somebody help me?
View Complete Post