Hi fraanchtoast and welcome to the forum,

In a quick read of your code, that is running behind Access, you have "ActiveWorkbook". I'm not sure Access knows what an ActiveWorkbook is.
Could that be the problem? Is there a way to close the file without using ActiveWorkbook?