I am attempting to write a code that with prompt to open a user specified file, copy a selection of data, paste the data into another workbook, then close the file the data originated from. I've gotten most everything to work except I can't figure out how to re-active the file to close once the data has been pasted since the file name was selected from a prompt. Any help to finish this out would be appreciated. here is what I have so far.
Please Login or Register to view this content.
Bookmarks