In SPOTRATE sheet there's two macro, actually the same just import different section from database (I'm sure both are existed and active!), however "update 01" macro works all right, but "update 02" doesn't.
Actually "update 02" successfully connected with database, whereas import nothing, with error msg box "Requeste: exec ps_GET_PNL '20120208','20120209','5J9' Operation is not allowed when the object is closed".
I attach the excel file here, anyone can help is highly appreciated!!
Thanks very much!
Have you stepped through the code to see where the error actually occurs? You don't appear to have any code that checks whether you got any records back before you try and use the recordset.
Good luck.
The execute command will return a closed recordset if the query is a non row returning query. What does your stored proc return?
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks