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
Bookmarks