View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
 
Posts: 128
Default .csv file conversion

Save it as a text file

Open excel

click record macro

open the text file in excel

insert your arrays (column breaks)

click next

And your almost there

Click stop recorder

If you save the script next time it will automatically break the file down
into excel format

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1