Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 20th 08, 05:35 PM posted to microsoft.public.excel.programming
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

  #2   Report Post  
Old February 20th 08, 05:39 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 35
Default batch process to covert file to excel file

one more thing, the "Adjustment for xxxxxxxx|$10.00" , need to change
the word "for" to "|" so that separate the "xxxxxxxx" to another field
too
  #3   Report Post  
Old February 21st 08, 02:13 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 35
Default batch process to covert file to excel file

Any one can help me, pls~~~
  #4   Report Post  
Old February 22nd 08, 07:35 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 35
Default batch process to covert file to excel file

Who can give me some suggestions on how can I do it? is it can done
on Marco?
  #5   Report Post  
Old February 22nd 08, 10:09 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default batch process to covert file to excel file

I don't think many people can figure out where you get each of those 5 fields.

wrote:

Who can give me some suggestions on how can I do it? is it can done
on Marco?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I covert a pdf file to a excel file? Gmaine2 Excel Discussion (Misc queries) 2 April 16th 07 06:48 PM
Excel to Run a Batch File?!? carla New Users to Excel 3 January 20th 07 02:32 AM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM
Run a batch file from Excel Tempy Excel Programming 7 May 18th 05 01:41 PM
Create a batch file from a number of Excel File Vinay[_2_] Excel Programming 0 September 8th 04 01:11 AM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017