Code to copy data from a closed workbook and paste in active workbook using named range.

Good day!

I have the following code which successfully:

1. Opens a CSV
2. Copies a range in the CSV
3. Pastes values in active workbook
4. 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!

Paul

Please Login or Register  to view this content.

Thank you Izandol,

However the sheet name "QU14022539" needs to come from a cell reference too. ie. Range("Sheet_name")

This is what i have now which is working.

Please Login or Register  to view this content.

Hi Naveed,

Your code works perfectly however can you change it to open a specific CSV from a cell reference rather than the dialog box?

much appreciated,

Paul

Originally Posted by Naveed Raza

try this code

not tested

Please Login or Register  to view this content.

hope this will work for u

Thank you both so much for your help!! Really appreciated!
Izandol, I used your last code. Like a charm!

Regards,