Import dynamically named files using macro

[Jeff Marcum]

I have a database set-up to do file comparisons. I import the files into
the database and do the comparisons with queries. I have to do this
comparison on a daily basis so I would like to set up a macro to do it. The
problem I have is that the names of the source files that are imported
change everyday. The date is appended to the file name. The format of the
file name is 'filename mm-dd-yyyy.txt'. Is there a way to write a macro to
import files when the name of the source file changes everyday?

[Tom van Stiphout]

On Tue, 11 May 2004 10:01:36 -0400, "Jeff Marcum"
<je********@consultant.com> wrote:

Presumably you are using DoCmd.TransferText. The filename argument
could be:
"filename " & Format$(Date,"mm-dd-yyyy") & ".txt"

-Tom.

I have a database set-up to do file comparisons. I import the files into
the database and do the comparisons with queries. I have to do this
comparison on a daily basis so I would like to set up a macro to do it. The
problem I have is that the names of the source files that are imported
change everyday. The date is appended to the file name. The format of the
file name is 'filename mm-dd-yyyy.txt'. Is there a way to write a macro to
import files when the name of the source file changes everyday?

[Jeff Marcum]

I was trying to do this just using the TransferText action within the Macro.
Can what you are suggesting be applied to that?

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:4m********************************@4ax.com...

On Tue, 11 May 2004 10:01:36 -0400, "Jeff Marcum"
<je********@consultant.com> wrote:

Presumably you are using DoCmd.TransferText. The filename argument
could be:
"filename " & Format$(Date,"mm-dd-yyyy") & ".txt"

-Tom.

I have a database set-up to do file comparisons. I import the files into
the database and do the comparisons with queries. I have to do this
comparison on a daily basis so I would like to set up a macro to do it. Theproblem I have is that the names of the source files that are imported
change everyday. The date is appended to the file name. The format of thefile name is 'filename mm-dd-yyyy.txt'. Is there a way to write a macro toimport files when the name of the source file changes everyday?

[Jeff Marcum]

Nevermind - I converted the macro to a Module and used Tom's suggestion. It
works just fine. Thanks

"Jeff Marcum" <je********@consultant.com> wrote in message
news:c7**********@mailgate2.lexis-nexis.com...

I was trying to do this just using the TransferText action within the Macro. Can what you are suggesting be applied to that?

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:4m********************************@4ax.com...

On Tue, 11 May 2004 10:01:36 -0400, "Jeff Marcum"
<je********@consultant.com> wrote:

Presumably you are using DoCmd.TransferText. The filename argument
could be:
"filename " & Format$(Date,"mm-dd-yyyy") & ".txt"

-Tom.

I have a database set-up to do file comparisons. I import the files intothe database and do the comparisons with queries. I have to do this
comparison on a daily basis so I would like to set up a macro to do it. Theproblem I have is that the names of the source files that are imported
change everyday. The date is appended to the file name. The format of thefile name is 'filename mm-dd-yyyy.txt'. Is there a way to write a

macro

toimport files when the name of the source file changes everyday?