opening newest file in a directory within a macro
opening newest file in a directory within a macro
(OP)
Hi all,
Thanks again for your help with the getting numbers from a column issue I had earlier.
Now the next problem(s)
I want to run a macro that opens the newest file in a directory, extract some data from it and save this in a new file with a name that will include some data within the file (probaly the time)
I think this will be my first experience with Visual Basic but I would like some pointers as to where to start.
thanks again
Steve
Thanks again for your help with the getting numbers from a column issue I had earlier.
Now the next problem(s)
I want to run a macro that opens the newest file in a directory, extract some data from it and save this in a new file with a name that will include some data within the file (probaly the time)
I think this will be my first experience with Visual Basic but I would like some pointers as to where to start.
thanks again
Steve





RE: opening newest file in a directory within a macro
HTH
dan