You could declare the variables as public at the top of a standard module, and set their value in the Workbook_Open event procedure in the ThisWorkbook module.
But you'd have to be very careful: if an unhandled error occurred, the variables would lose their values.