Please take a look at the attachments. I would like to import the .csv file into excel using VBA and have written the code. It is not working exactly as planned.
Ultimately I would like to have the ID in column A, Last name in B and First name in C.
Currently, my ID and First Name is combined in Column A which is not what I want. Also it doesn't seem to loop.
Thanks!
authors.csv
Please Login or Register to view this content.
vbatestfile.xlsm
Last edited by potterotter; 06-11-2014 at 07:17 AM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks