Ok, I have ran into a large problem that I can't figure out. We have a
data machine that dumps a file at the end of the day with all the data
it has recorded for the day. It is decimal delimited format and I have
about 100 of these files with another one added each day. I need to
condense all this into one file that you can look at and find
information quickly. What I need to do is have each row represent a
day, and all the information from that day goes into the respective
columns for that day(Row). I originally thought I'd be able to to this
through the use of macros but after recording my own macro I have found
that there is no way to automate it to execute the same commands to
multiple files. I would appreciate any ideas anyone could offer because
my current situation with seperate files is very inefficient and harder
to search through.

Thanks,
Keith


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529

Keith,

Do the individual files open as single row spreadsheets when opened by Excel?

HTH,
Bernie
MS Excel MVP


"mfx_krypt" wrote in message
...

Ok, I have ran into a large problem that I can't figure out. We have a
data machine that dumps a file at the end of the day with all the data
it has recorded for the day. It is decimal delimited format and I have
about 100 of these files with another one added each day. I need to
condense all this into one file that you can look at and find
information quickly. What I need to do is have each row represent a
day, and all the information from that day goes into the respective
columns for that day(Row). I originally thought I'd be able to to this
through the use of macros but after recording my own macro I have found
that there is no way to automate it to execute the same commands to
multiple files. I would appreciate any ideas anyone could offer because
my current situation with seperate files is very inefficient and harder
to search through.

Thanks,
Keith


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529

No, that would have made this alot easier to do. Each file consists of
about 300 rows, which I need to average before inputting them into the
condensed spreadsheet.


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529

Average in what way, and where does the resulting data go? Get specific.

HTH,
Bernie
MS Excel MVP


"mfx_krypt" wrote in message
...

No, that would have made this alot easier to do. Each file consists of
about 300 rows, which I need to average before inputting them into the
condensed spreadsheet.


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529

Just to add to Bernie's questions...

What do the input files look like. Decimal delimited sounds kind of vague
(well, to me).

Is it one value per line--just the number?
Is it two values per line--maybe a date and number?

Where are all the files located--in a dedicated folder with nothing else in
them. It might make it easier if that could be done. Then the macro could open
each file it finds in that folder.

How do you tell the date of the data--is it the name of the file????

Bernie Deitrick wrote:

Average in what way, and where does the resulting data go? Get specific.

HTH,
Bernie
MS Excel MVP

"mfx_krypt" wrote in message
...

No, that would have made this alot easier to do. Each file consists of
about 300 rows, which I need to average before inputting them into the
condensed spreadsheet.


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529


--

Dave Peterson

Ok, sorry for any confusion. The format of the text file is like this

09/22/05 12:30:21,1.34,3.27,0.345,0.0043,2.34
09/22/05 12:30:26,1.33,3.27,0.341,0.0050,2.39
09/22/05 12:30:31,1.45,3.31,0.401,0.0046,2.29

And it goes on, about 15 values per row and about 300 rows, each column
needs to be averaged for that day - so for example you would average
1.34,1.33,1.45 and get 1.373, you would than input that value into the
next spreadsheet and average the next column.

Also to answer the other question, file formats are in terms of dates -
something like 092205.HV2 (it has hv2 extension but its just a decimal
delimited text file). And yes they are in a dedicated folder.


--
mfx_krypt
------------------------------------------------------------------------
mfx_krypt's Profile: http://www.excelforum.com/member.php...o&userid=22040
View this thread: http://www.excelforum.com/showthread...hreadid=469529