Import Excel file using headers

[albertod8]

I would like to import a CSV/Excel file using VBA, however file could be dynamic from month to month and would like to use the headers. Is that possible?
Headers would be:
- Policy - import column A
- Country - column B
- Address - column C
- Customer - column D

Thanks!

 

[alansidman]

You might consider using Power Query (called Get and Transform Data in your version) and found on the Data Tab. No coding required when you use this Excel Native functionality.