Csv to excel

[nexx]

Hi guys
Am new to forum. I never actually work so much with excel nor I know it.

I have one time job/task to do:
I have File.csv file that looks like:
-----------------------------------------------
"Time","One","Two",...."UpTo40"
08/27/2010 12:45:42,77,56,44,55,77,86...until_40
-----------------------------------------------

Text from above is linked to value below eg:
One=77
Two=56
Tree=44 etc..

What I would like to make is to:
Load all these text/digit values to its own columns in excel on click of button:
B10 = text example One
C11 = value blow which is 77

B11 = text example Two
C12 = value below which is 56

....and so until B50 C50..


Can someone help?
Thanks in advance


:

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[nexx]

Ok Roy m8..
I'll make those two..

[nexx]

Ok, here are both file:
csv (read from file)
parser (which actually looks like what am trying to make)


Thanks in advance

[royUK]

Is it one line of data per csv?

[nexx]

Yes Roy.
Only one csv file to read from to Excel file.
Only one line. Actually first line is "text" second is digit.

Thanks m8

[royUK]

I can't see why you don't just manually copy from the csv then paste special -> transpose, or do you have several files to do this with?

[nexx]

Roy, 'cos it needs to be like that, automatically

This *.csv is generated by other software, and it generate file every month (a csv file).
Jan\File.csv
Feb\File.csv
etc...

I just need this "base of parsing from-to".. so i can add more stuff to it, example:
Run it automatically every 30days and read from last month file.csv and save to
C:\Report\Jan\Report.whatever.html.doc etc..
But this in "future" .-))

I hope you understand what am trying :-))

[nexx]

anybody :-((

[royUK]

Start by using the Macro Recorder., post back for help with the generated code

[nexx]

Roy, i did some homework.. i got something but its not quite working... ((

Please Login or Register  to view this content.

[nexx]

Got it with macro recorder, easy.
However I got another problem. If I modify text/value in csv, the same values are inserted in cells.
How to modify code to copy what is btw " ".

File csv content:
"Time","Ole","Two","Tree","Four"

Please Login or Register  to view this content.

ActiveCell.FormulaR1C1 = ?