I created an Access macro to simply export a table to excel. Each month I want to export the same exact table to excel, except the folder needs to change (based on the current month's name).
For example: when the file is transferred to excel, the folder location is say N\Users\Reports\May Reports and the name of the file is "report_data". The name of the report can stay the same each month, but in June I want it to be transferred to the N\Users\Reports\June Reports folder.
Is there a way to create a prompt in which I enter the month name/abbreviatino and it puts that name into the folder's address automatically? Does that make sense?
Thanks in advance for any help.
For example: when the file is transferred to excel, the folder location is say N\Users\Reports\May Reports and the name of the file is "report_data". The name of the report can stay the same each month, but in June I want it to be transferred to the N\Users\Reports\June Reports folder.
Is there a way to create a prompt in which I enter the month name/abbreviatino and it puts that name into the folder's address automatically? Does that make sense?
Thanks in advance for any help.