View Single Post
  #1   Report Post  
Old February 20th 08, 05:35 PM posted to microsoft.public.excel.programming
[email protected] beancurdjelly2003@yahoo.com.hk is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 35
Default batch process to covert file to excel file

Hi All,

I need to covert many many file to excel file format and save as
another folder by daily, who can help me to write VBA. So can let me
simpliar the job process. Many thanks!

I'm not sure what type of the orginal file format. I open with
Notepad, then see the file use "|" to separate each field, look like
below

Name:xxxxxxxx|
Adjustment for xxxxxxxx| $10.00

Mobile|Account|Free Min|Feature1|Feature2|
xxxxxxxx|xxxxxxxx|1000|15.56|1000.34
xxxxxxxx|xxxxxxxx|(10)|323.00|45.00