Hi, I got the solution of this solution. It was happening due to combined effect of - 1) Keeping few EG sessions on. These sessions had successfully executed the libname statements earlier. So possibly there was some kind of lock held on the excel file, by these EG threads. 2) Access issue- The location where excel file was kept, had limited access. After I placed the file at some other location and closed all the EG sessions(and other DI studio sessions as well) referring to it, I was able to run the code in DI Studio as well register tables(Excel worksheet) from the library. Though the description of the error was really a confusing one. Cheers Yugesh
... View more