Anyone know how to prevent Excel 2007 from displaying the Opening progress dialog (with the cancel button on it) when opening a big spreadsheet from VBA? I thought that turing Display alerts off would do it, but no luck.
I tried making Excel invisible during the open as well but no improvement.
Application.DisplayAlerts = False
Set wb = wbs.Open(Filename:="test.xls") 'opening dialog displayed w/ cancel button