I have some code that I run every Saturday and Sunday at 2:00pm in a
Workbook.

Is it possible to somehow automatically run this macro without the
workbook being actually open and without me actually been present?

I would have the exact Date and Time that I want it to run at in a
cell, say A1. Reason I have this is that I use a new copy of the
workbook each week, so I only want the current file to run, not all
the historic files too.

Thanks