I coded a macro that opens another workbook and then extracts information from it and finally closes it without saving. It worked smooth.
Now my requirements have changed. I have instead few workbooks to choose from to extract the data based on few criteria. I was wondering if a macro can be coded that would allow me to do so. Basically when the macro is executed, it should throw a "open file" window allowing me to choose the file of my choice. I then pick the file and the macro does the rest.
Thanks for any help.
DD
Bookmarks