Import specific columns of CSV in Excel 2007

Question

Hello,

I have a csv file, which consists of many fields (columns). However, I would like to import some columns while not others. Every time I am importing csv files with same structure and selecting columns one by one takes much time. How to automatically select the columns imported? DO I need a template or VBA code? (I am lack of programming skills):(

Thanks in advance,

Best

Answer 1

Hi,

I recorded a macro. I decided to edit codes of macro. However I got stuck in somewhere. The problem is that: Every time when I run the macro, the same csv is imported. What I want is that: macro should let user to choose the file Macro should let user to import into whatever cell the user wants

Could you please help me? Thanks in advance

Best,