hi,
thanks for the suggestion, but my problem is not yet resolved.
Actually I want to open a excel workbook which contains multiple
worksheet. Each work sheet has column name. Now i want to check if the
column name given in that particular worksheet is (eg sr. no, class
name, parent name, description), if it matches then only open that
work book otherwise pop up a error message.so what should be the macro
code for that....

thanks in advanced
suraj