in reply to Re^6: Reading Excel
in thread Reading Excel

Your code open creates a new excel instance, then dies because (seemingly) it can't open a file. You said:

"I am unable to deal with Excel also."

To many reading this it would seem that the situation you now report:

"Normally if i open in Excel it is opening"

The two can't be true. Perhaps spend some time on your posts, be detailed and descriptive in what is actually happening.