Thread: Excel 2007

hi everyone

just wondering if anyone can help me, i have the following problem

i extract a report from a web based jobcosting program and i get a text file, and previously i have converted this file into an Excel file and i would get up a wizard which would allow me to de select 'tab' and select 'comma' as a column seperator and then the fiel would be opened in Excel and i would have to do a little tidy up, but nothing major

now i am using Excel 2007 i dont get this option and the text file automatically selects Excel 2007 and opens it, but it enters all the information into one cell on each row

how can i get round this without having to send it to another machine using an earlier version of Excel

many thanks

thanks for that....sorted it by just messing around

now i have wrote some code to do this with a click of a button

thanks again