macro required to format csv file with pipes into excel

[mingandmong]

Hi

I have to import a .csv file into excel and prepare the worksheet before i can use it, can a macro be written

currentley i hace to

a) paste .csv into excel
b) select column A
c)txt wizard comes up select delimited, then next
d)populate other tab and put in pipe | then next
e)then select txt for 2 of the columns instead of general (column F & G) before finnish

[B]today[/B]  with pipe ( data should be coulmn a, b,c,d,e,f,g,h,i,j,k, but got muddled and placed all in A

[TABLE]
 <colgroup><col style="font-weight:bold; width:30px;  "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>[TR="bgcolor: #cacaca"]
[TD]*[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD]7264164|ACPcted_|COM||||||2014-11-28 05:18:10|2014-11-28 14:15:43||[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
</tbody>[/TABLE]
 
[URL="http://www.excel-jeanie-html.de/index.php?f=1"]Excel tables to the web - Excel Jeanie Html 4[/URL]
]

[CODEtoday after completing wizard

*	A	B	C	D	E	F	G	H	I	J	K
Hargreav	COM	PM	61N0260	22C710
Hargreav	COM	LD	21H7430	22P010

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]22[/TD]
[TD="align: right"]8324960[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1325739[/TD]

[TD="align: right"]########[/TD]
[TD="align: right"]########[/TD]
[TD="align: right"]00:05:12[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: right"]8324960[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]4865360[/TD]

[TD="align: right"]########[/TD]
[TD="align: right"]########[/TD]
[TD="align: right"]00:02:49[/TD]

</tbody>

Excel tables to the web - Excel Jeanie Html 4

][/CODE]

 

[Andrew Poulsom]

Have you tried recording a macro while parsing the data manually?

 

[mingandmong]

Hi Andrew, being a total newbie i do not think the record a new macro can work whilst the the wizard is active, i bow to your knowlege due to helping me in the past ?

 

[Andrew Poulsom]

Turn on the macro recorder then activate the Text to Columns Wizard.

 

[mingandmong]

Turn on the macro recorder then activate the Text to Columns Wizard.

hi Andrew, i thankyou once again, macro recorded and works as intended