• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

how to convert .csv file to xlsx file with tabs

I want to convert csv to .xslx and put the data in tabs based on certain criteria, is there a way to do it thru excel macros or vb program.
0
panthi
Asked:
panthi
  • 3
  • 3
  • 2
1 Solution
 
Hendrik WieseInformation Security ManagerCommented:
You simply open the CSV file and then save it as .xsls.
0
 
Hendrik WieseInformation Security ManagerCommented:
So open the CSV file using excel, and then save the file as xsls extension which will allow you to use all the excel functions, macros etc.
0
 
panthiAuthor Commented:
May be i am not clear. i understand that i  can do saveas, i basically want to automate this, that is the real question.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CodeCruiserCommented:
What is the criteria for dividing to tabs? You would have to use Office Automation.

http://support.microsoft.com/kb/302094
0
 
panthiAuthor Commented:
the criteria is value in one of the column
0
 
CodeCruiserCommented:
Did you try the automation example?
0
 
panthiAuthor Commented:
To make it more clear this is what my task is
there is a csv file that is created by a program every day
I need to read that csv file based on the date and create a xlsx file as an output with seperate
tabs for each state. What is the most efficient way to do this i dont think automation example is right for the scenario mentioned.
0
 
CodeCruiserCommented:
Given that you need to create additional sheets in xlasx file based on your criteria, I think automation is your only choice.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now