MrExcel Publishing
Your One Stop for Excel Tips & Solutions

closing files


Posted by Steve Fairhurst on November 16, 2001 6:59 AM

I am working with text files that have benn sent by a Unix system to my PC.
After opening and importing the data into my spreadsheet I need to close these files.
I use the VB macro command ActiveWindow.Close
But...
The system always pops up the save to clipboard message which I must answer yes or no to.
Is there a way to bypass or close this prompt without operator input? A VB command I can use in my Macro?
Thank you
Steve F.


Posted by NiuB on November 16, 2001 7:05 AM

Hello..

why don't you use :

Sub auto_close()
application.quit
end sub

HTH

Posted by Barrie Davidson on November 16, 2001 7:13 AM

You could try this

Application.DisplayAlerts = False
ActiveWindow.Close
Application.DisplayAlerts = True

Regards,
BarrieBarrie Davidson

Posted by Steve Fairhurst on November 16, 2001 9:41 AM

Posted by Steve Fairhurst on November 16, 2001 9:41 AM

Posted by Steve Fairhurst on November 16, 2001 9:44 AM

While trying to post my thanks to those that replied I may have posted the original message again. My newness to the sight is showing.
so Sorry.

Thanks for those that have responded I will try both of the solutions.

Steve