Hi FWind.....
sorry....but the code actually threw up an error when I ran it in the actual XL File. It worked perfectly in the experimental files i had created......
when I run this code in the actual Excel File (that incidentally contains more than 800 Macros) I get a "Compile Error....Cant find Project or Library" on the wn.close line....
As far as my knowledge goes this error relates to something like "Microsoft Excel Object Library" and MS Office OL" not being ticked in the References menu in macros
But believe me both are ticked and the code works on other XL files but not this.....
now where it is getting botched up?????
pl guide me....
again a million thanx