Hi there,
I currently use the following VBA code to find the most recent file within a folder, open it and copy the data to another sheet. I'm looking for a way to close it again afterwards.
Currently I am relying on the user by presenting them with a prompt box, I would like to avoid this altogether. Does anyone have any suggesstions?
in addition I'm also wondering if it would be possible to enter the file name (actually part of the filename) returned with this code into a specific cell within the worksheet?
Many thanks in advance.
Bookmarks