I am looking to add an if function (i think) to my report runner in excel. currently it opens an Access database and runs some code but on certain dates (weekends and bank holidays) i want to run a different bit of code in access.
My question is this a) Can i use a list of dates in VBA i.e
if Date = "01/01/05","02/01/05 then 'run other code' else 'normal process'
b) if so how do i separate the dates (i have about 107 of them)
c) or am i way off the mark and can someone please advise on this.
Many thanks in advance for any time taken to help.