changing the value format problem

Hi Guys,
I have the following challenge.
Everyday I receive a text file (uploaded automatically to the catalog C:\Users\aa\Desktop\files
They are automatically imported by another program and here is a problem: Format of the files have changed (before values had 2 decimal places like 100.10 USD and new files have four decimal places like 100.1010 USD).
Program that imports that data cant understand the new format and is unable to do rounding and I receive ERROR.

My idea is as follows.
1. Create macro that automatically imports the data from this catalog to xls
2. Performs the rounding to 2 decimal places
3. Exports the file to the txt format with 2 decimal places
4. Run that macro from Windows scheduler at a certain time

I belive it is as easy as ABC isn't it?

txt file structure:

No Time Value
1 1-Jan 12323.2121
2 1-Jan 22323.3132
3 1-Jan 32323.5142
4 1-Jan 11323.2111
5 1-Jan 323.7101

Hi.
You say you receive file as text, do we read this to mean .csv ?
e.g. No,Time,Value
1,1-Jan,12323.2121
A good start would be a copy of two or three lines of actual file that is uploaded, including all headers.
torachan.

If the only purpose of importing to Excel is to perform rounding, you could just manipulate the text file directly using vbscript.
Assuming the data is delimited by a space:

Copy to Notepad and save as filename.vbs

Please Login or Register  to view this content.