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!
Bookmarks