Hi Guys,

Thanks for the replies, but my problem is solved and its due to syntax error.

workbooks.open(filename,0,.....) is working fine, when declared filename as below:

filename = "\\\\servername\\foldername\\excel.xls"

need to mention 1 extra for each "\".