Hi, when I execute a T-SQL command (which have IF Condition or CASE WHEN THEN statement) using excel macros I am getting a error "Item Not found in the collection..... ". But the vba excel macro is executing and giving the proper result when I don't use IF or CASE statements in the SQL command. Because of this I am facing problem... Can anybody tell me how to overcome this.
Comment