var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: overwrite prompt.. how do I stop it?
Does anyone know how to stop the verification message "a file named morning report data.xls already exists in this location. Do you want to replace it?"?
My code is as follows:
ActiveWorkbook.SaveAs "morning report data.xls", and the answer should always be YES!
By the way, where is everyone? No one has added anything to this site since my last update on 10/28/05!
Nevermind, I just figured it out.
Application.DisplayAlerts = False