PDA

View Full Version : Import data from selected sheets of other wb



sujittalukde
10-23-2007, 11:05 PM
Can a macro be provided to import data from other workbook based on sheets of that WB to be selected by the user?
Suppose there is a WB saved in D:\ having 25 sheets.
Now the user is working on a new WB and he needs to import some data from the saved WB from any of the 25 sheets.
I wnt that on running the code, the code will show the opendialog box to select the file. On selecting the file the code will ask for the sheet name to import (via Input box or list box which will list the 25 sheets name). On selecting the sheet name, the data will be copied to new WB on the selected sheet from where code is run.