Building Macro's in MS Access to Import text files with a variable name?

  • Thread starter Thread starter Stefanie K
  • Start date Start date
S

Stefanie K

Guest
Hi, this is my problem: I have a lengthy macro set up in Access to import a text file on a daily basis. However, this macro only picks up the text file that is indicted with the pathfile (example: C:/My Documents/My Folder/CC081110.txt; and it will not recognize the text file if it is changed on a daily basis. The text file's name actually stands for the date (CCyymmdd.txt). Is there a way for the macro to recognize the change in the name on a daily basis? Possibly a pop up box that allows the user to end the date that would somehow attach to the file name? If you need clarification please let me know. Thanks!
 
Back
Top