I have the following code which successfully:
- Opens a CSV
- Copies a range in the CSV
- Pastes values in active workbook
- Closes CSV
However I need the code to open a different CSV each time (based on a named range not a file path).
Could someone please have a look at the below code and help me in correcting this?
Thanking you in advance!
Please Login or Register to view this content.