Hi,

I have a requirement.
The excel sheet will look like this and there will be multiple sheets like this sheet
---------------------------------------------------------
aa abc dshfji sdjfn
ds df df

col1 col2 col3 col4 col5
1 x a b s
4 x b s
5 x b s
-----------------------------------------------------------
data we need from the sheet range from B4 - F7

i need to write a macro to read the multiple sheets and save it as a text file.

There will be one excel sheet; in that excel sheet i will be giving the sheet name from-cell and to-cell
e.g
Sheet1 B4 F7
Sheet2 B5 F8
Sheet3 C4 G8

The macro need to read this excel file and open the sheets one by one and get the content from the sheets from specified range and save it as a text file

Kindly give me the solution

Thanks In Advance
S. Sathish Kumar