MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Keeping automation XL files "invisible"

Posted by VBnewby on January 26, 2001 1:06 PM

I have an automation prog that opens and looks (GetObject()) in an xl file, at a special sheet, then leaves. I don't want this file to be visible at any time. It does get changed, but it never needs to be saved.

The program works great, but how do I get out and close this 'xl.application.Visible = False' remote XL file without the "Do you want to save the changes..." box popping up???

Posted by Garland on January 26, 2001 9:03 PM

Try inserting 'application.displayalerts = False' as the first line of your macro.
This should eliminate the 'do you want to save....' message from displaying.

Posted by vbnewby on January 30, 2001 6:11 AM

Re: Keeping automation XL files

HEY IT WORKS!!! THANKS LOADS!! the XL file will now stay undercover...