Now I am saving using the following way:
Wbk.SaveAs Filename:="D:\folder\filename.xls", FileFormat:=56, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
56 is for .xls format. Now the result workbook is opening without any fuss.
Phew..!!