Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
batch process to covert file to excel file
Any one can help me, pls~~~
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I covert a pdf file to a excel file? | Excel Discussion (Misc queries) | |||
Excel to Run a Batch File?!? | New Users to Excel | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
Run a batch file from Excel | Excel Programming | |||
Create a batch file from a number of Excel File | Excel Programming |