PDA

View Full Version : Help! converting a txt(csv) to excel


cocoonfx
01-08-2009, 08:28 AM
Hello Chaps


I need some urgent help! our VB script person at work is being difficult and i urgently need to convert a txt file to excel using a batch job. Does anyone know where i can get the script (VBA) so i can show what an idiot this bloke is. :mrgreen:

edbr
01-08-2009, 08:41 AM
http://www.softinterface.com/Convert-XLS/Features/Convert-Fixed-Width-Text-File-To-CSV.htm
http://www.ozgrid.com/Services/text-converters.htm

maybe

davidj
01-13-2009, 08:36 PM
would need to see an example of the text file to see what you need and what delimits the text into columns