Hello All,
Is there a method to code a macro or module in access to automatically update components of a file name and Directory to the previous month date?
HERE'S MY CODE:
ext acExportDelim, "Export Specs_FWB-FHL Summary", "SelQry FHLSummary_CHAMPEI", "M:\Cargo Group\MIP\MIP Reports\06-2010\CHAMP_EI201006FHLSUM.CSV", True, ""
The example above is for June reports which is processed in July. The data in red needs to be updated automatically to the previous month date using this format: MM-YYYY and YYYYMM. In my current process I am manually updating about 60 queries in the macro module at the beginning of each month. My plan is to eliminate this step by automating the naming process.
Please note I have minimal experience with VB Code and the modules in Access, I used the 'Convert Macro to Code' feature to obtain the vb code.
Any help in resolving this issue is much appreciated.