Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to access .csv files through Excel macro?

 
Mani Raju
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I required to access ".csv" file through Excel macro!

Any one could you please help to create macro in excel to access content of ".csv" format file!

Thanks in advance!


 
Tony Docherty
Bartender
Posts: 2958
59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This has nothing to do with Java so I'll move this thread to our Other Languages forum.
 
Piet Souris
Rancher
Posts: 1268
28
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can open a ".csv" file in Excel directly. So what's the problem?

You may have to apply the menu option "text to columns, but that'll take you a couple of seconds at most.

If you MUST open a csv file in VBA, then just start recording a macro, open the file in the usual way,
do the text to columns if necessary, stop your macro and look at the generated code. That's often the fastest
way to learn VBA.
Having loaded this csv file into a sheet, you can read all of it using standard VBA code.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic