>OK, back to my original question. How do I set the path that the Excel file will be saved in if the user decides to save the file? (Of course, the user could override this by doing "Save As" on their own.)

I don't think it's possible but I don't know that for sure.