Hello,
Is there a way to do this?

a) run a code that will create a pop-up window with the question, "Can you show me where the CODEMAP.txt" file is?"

b) then the user will locate the file in a pop-up window and be able to click/select the file and there are "ok" and "cancel" buttons.

c) once the "codemap.txt" file is selected, the vba code will automatically change this file to "codemap.csv" so that it will open in excel (temporarily). This file can be placed anyway, even on the desktop because it won't be needed later. This is only temporary.

d) Then on the "codemap.csv" file, everything from sheet 1, cell b1 to cell b700 are copied and pasted to sheet two of this macro

The codemap.csv file can then be deleted


Thank you