Guys,
After several hours of ‘googling’, my hopes are on you for solving my VBA csv-import problem. The problem is the following:
I’m trying to import several semicolon separated .csv files in one Excel worksheet (multiple tabs). The import works fine, but the separation in different columns doesn’t go well. The most solutions I found work fine for one csv file, but don’t work in my code:
Please Login or Register to view this content.
Who can help me out? Your advice is truly appreciated!
Ivo
Last edited by pike; 06-14-2010 at 05:48 AM. Reason: Add tags for newbie
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Hi Ivo,
Do you want each csv file to be imported into a new tab or all in the same tab?
abousetta
I all want them to be imported in a new tab.
or even simplerPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by snb; 06-14-2010 at 07:13 AM.
Opens a dialog box asking for the folder and then imports all the csv files from that folder.
abousettaPlease Login or Register to view this content.
Thanks Abousetta,
this works nice. I think my answer to your first question was a little vague. But I actually want each csv file to be imported to it's own tab. Preferably I want the tabs to get the name of the corresponding csv-file. Do you have a solution for that?
Ivo
PS. Dit lijkt me een stuk eenvoudigerPlease Login or Register to view this content.
Much simpler I'd say
I agree that snb's approach is simpler. Snb would you care to elaborate on the approach so we can learn from it and be able to modify/ reproduce it in the future.
abousetta
Can you please suggest me how to add the csv file name in the first column in the above code from abousetta
Hello @timepass_2,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Now that we got the formalities out of the way, another poster had a similar question to yours. Here you will find a newer version of the code above and here you will find another version of the code using the Dir method and incorporating the file name. If you still problems modifying either code to your needs then please start a new thread and PM me the URL.
Good luck.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks