Need help with "Compile Error: Type Mismatch"

Question

I have a procedure to export some queries from Access to Excel. It worked yesterday afternoon, but today it's giving me an error. I'm pretty sure I didn't make any changes since the last time it worked, and the type mismatch isn't making sense to me. Here's the portion of code that's raising the error:

I have variable declaration earlier in the procedure:

Only the 3rd query def is causing an error even though it follows the same format as the previous 2. What's the problem here?

Answer 1

Nevermind, y'all. I figured out the issue. Apparently I added an additional where condition to the SQL string and put it outside the close parenthesis of the function arguments 🤦‍♂️