Originally Posted by
Parth007
Try this
OPen The file & Click the button to proceed..
Hi Parth007,
Thank you for your reply.
The code is working, but it doesn't get me the things I really want.
Below code is using the assumption that the user only have one and only one file to retrieve the data, which the file name is "Want to close this.xlsm".
I wish that the macro can close the selected file, for example: "File1.xlsm", "Potato.xlsm", "Sales June.xlsm" etc.
Because the user can select the file that they wanted to retrieve the data.
Anyway, thank you very much for your efforts. Really appreciate it.
If you have any better idea, feel free to share.
Bookmarks