![]() ![]() Step 2 ' DateAdd function allows one to soft-code a date referencing a ' pre-defined date ' The code below would return 202112 at time of writing, which is 3 ' months in arrears to March 2022 date_string = Format(DateAdd("m", -3, Now), "yyyymm") ![]() Step 1 ' Open the system generated report ' path needs to be defined as path to directory of the system ' generated report Workbooks.Open Filename:=path
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |