I have a spreadsheet that runs a macro that switches between it and a second
spreadsheet, merely moving data from the second to the first. The macro then
closes the second spreadsheet. My problem is that it prompts the user to save
before closing, and I want to remove this prompt.

I tried this line: ActiveWindow.Close.Save = False. Purely guessing, but
typed in all lower case and VBA properly capitalized it, which has always
been a sign that I've guessed right or type in variable names correctly.
However, I'm getting the following error: Compile Error: Invalid Qualifier,
and the .Close is highlighted.

Can someone tell me what the statement I'm looking for actually is, and if
you have the time, explain that error to me? Very much appreciated for any
help anyone can offer.

Dan