Hi,

I need a macro or VBA coding to do the following repetitive action :

1. Data - Import External Data
2. Go to H:\My File\001_01.txt
3. Select 001_01.txt
4. Import as comma delimited file, start import at row 1, text qualifier ", column data format General
5. Finish
6. Insert new worksheet

7. Data - Import External Data
8. Go to H:\My File\001_02.txt
9. Select 001_02.txt
10. Import as comma delimited file, start import at row 1, text qualifier ", column data format General
11. Finish
12. Insert new worksheet

etc.

Thanks in advance !

I don't feel anything to do this manually.