Trying to close a window without saving
Thanks very much, Bob. Would I put that statement before the
ActiveWindow.Close statement? Seems like I would, but please let me know. And
thanks again.
"Bob Umlas" wrote:
Application.DisplayAlerts = False
Bob Umlas
Excel MVP
"danhattan" wrote in message
...
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
|