Hi MM,
Thank You for your reply. I got this far to read the Multiple files. However, my Excel file has different Layout in each Sheets. I can successfully read If I have
Sheet1 (Layout1)
Sheet2 (Layout2)
Sheet3 (Layout3)
Calling 3 different Packages.
In my Source file, it could possible
Sheet1 (Layout1) = Package A
Sheet2 (Layout2) = Package B
Sheet3 (Layout3) = Package C
Sheet1-a (Layout1) = Package A
Sheet1-b (Layout1) = Package A
I couldn't figure out, how Can I When Sheet1-a to call Package A. Any advise ?