LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default PLEASE HELP!!!!

I think the best way to start off is by explaining to you what I am
doing.

I have 5 machines that recored everything they do and save it in two
files, a txt and a dat file. When you put these two files together
they are called a data log.
The dat files has a bunch of numbers and the txt file has a bunch of
times and the steps and settings of the machine. For a while I would
have to manually get the numbers I needed but then I made a marco to
do this.
The macro i made (with lots of help) opens five of the datalogs (5 txt
and 5 dat files) pulls out the info I need and then copies that info
into a trend chart. Once that is done it closes them all and delets
them. The problem is that I have to manually move the five datalogs
into a folder for this marco to pick them up (it remames the five
files in those folders). It takes about 2 minutes for the macro from
start to finish so this means to get all the machines done I have to
sit at my computer and wait until its done and then manually dump five
more files into the folder.

So I think the easiest way to make this work is to get a macro that
can grab five files (unkonw names) and put them into a folder for me.
I need this macro to grab the files by date modified as I need the
oldest five files first.

Then once that is done I would like to loop my whole macro so it
continues to move the files in until all the datalogs are
completed......

CAN ANYONE HELP ME!!!!!

I have posted this a couple days ago but I haven't gotten any
responses.

 
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



All times are GMT +1. The time now is 10:08 PM.

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

About Us

"It's about Microsoft Excel"