Opening a file with code without a set file name
 

Hi all and thanks in advance for any help.

I have excel workbooks that are produced on a daily bases by another
program. The data layout is the same for each day produced except for
the file name. What im having to do now is rename the file every day
and then run my other code to clean it up and import the data into my
new workbook.
The code that i use works great but would like to be able to fix it so
it doesn't matter what the file name is, so that others won't have to
remember to change the name before they run the cleanup code. Any
ideas.
Thanks, Pat


--
jenkinspat

Hi

it would probably help if we could see the code, if you'ld like to copy &
paste it (or at least the bit where the file name is referenced) in a reply
this would give us a starting point ...
and also to know where you run the code from - is it stored in personal and
run via tools / macro / macros in the newly created workbook or ??

Cheers
JulieD


"jenkinspat" wrote in message
. ..

Hi all and thanks in advance for any help.

I have excel workbooks that are produced on a daily bases by another
program. The data layout is the same for each day produced except for
the file name. What im having to do now is rename the file every day
and then run my other code to clean it up and import the data into my
new workbook.
The code that i use works great but would like to be able to fix it so
it doesn't matter what the file name is, so that others won't have to
remember to change the name before they run the cleanup code. Any
ideas.
Thanks, Pat


--
jenkinspat