Every day i have to pull of a text document from a server and import it into excel so i can change the format of certain columns. Then import the data into a database. I am trying to create a macro that will enable other users to do this with out any hassle.

Is there a way to have the macro import the file automatically?

The file name is esrips.mis.print.ddmmyyyy and is delimited with the comma seperator.

the ddmmyyyy changes each day.

Thanks in advance