Can a macro be self-starting based on some event?

Events such as:
1) opening the file
2) preset time
3) value of certain cell contents

Trying to set a spreadsheet to run a series of queries and macros every
night.

Also hope to learn if i can set up a series of queries and macros to run in
sequence whether autostart or not.

Could these macros run even if the Excel file is not open?