01-31-2014 03:49 PM
I run the same process every month, the only change is the data I imput. Example: DataJan.xlsx, DataFeb.xlsx, etc.
It seems to me that if you can code a macro to pull Data&Month.xlsx and then just change what %let Month equals, there should be some way to take the coding out and create a prompt to do the same thing. The step I'm trying to take out is having to look at the code and identify what needs to be updated each month. Is there a way to run the code and have a prompt pop up telling me what to change?
I've been successful getting prompts to work for all of the tasks within a project, but I'm stuck on getting one to work with importing data. Any help is appreciated.