By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

Regarding executing T-SQL command using excel macros

P: 1
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.
May 6 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
I am moving this question to the Visual Basic forum.

May 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.