insert a csv file data into excel worksheet

[enemy_zone]

hi guys,

i need to insert data from a csv file to an excel worksheet (attached), using VBA/macro, not copy-paste.

the conditions are:
- can browse to located the csv file (from button in worksheet "input").
- data from csv file should be inserted below last data in that worksheet (not always from row 8).
- first row (as header) & first column in csv file not included; where:
- Question 001 - Question 010 should be in "ID No" column
- Question 011 - Question 022 should be in "NAME" column
- each question 023 - question 047 should be in column C to AA, respectively.


thank you

[xladept]

Hi enemy-zone,

The red instructions don't yet make any sense to me but, here's some of your requirement:

Please Login or Register  to view this content.

Is this what you mean??

Please Login or Register  to view this content.

[enemy_zone]

xladept,

your code saves my day... it works...
csv file is from omr scanner, and each character extracted to a single column/semicolon.

[xladept]

Hi enemy-zone,

Glad it worked and thanks for the rep!