I'd like to use a macro to import a text file that has the date as an integral part of the name such as WL-Jul13.txt or WL-Jul14.txt Each day, I want the user to start Access, have the user select the file to be imported (usually the for current date - but not always) and then Access will manipulate the delimited data file and print a customized report.
The users do not know Access so this needs to be user friendly and secure from user mistakes.
Once the user has entered the report date, I'd like to build a variable for the report name from the date. But it doesn't seem like I can use a variable for the filename in the macro design view. I thought maybe I could do this in SQL code but I'm not sure how to make it part of the macro.... Any ideas? THANKS!
The users do not know Access so this needs to be user friendly and secure from user mistakes.
Once the user has entered the report date, I'd like to build a variable for the report name from the date. But it doesn't seem like I can use a variable for the filename in the macro design view. I thought maybe I could do this in SQL code but I'm not sure how to make it part of the macro.... Any ideas? THANKS!