Display Alerts

  • Thread starter Thread starter scrabtree23
  • Start date Start date
S

scrabtree23

In Excel 2003 I wrote a code that briefly turns off "Display Alerts"

Application.DisplayAlerts = False
Windows("Employee DataBase.xls").Close
Application.DisplayAlerts = True

The code goes to the "Employee Database" file and closes it (the file the
code is in was pulling some data from that file.

Now we have Vista and Exel 2007. The file the code lives in and the
"Employee Database" file open and work properly in the new version of Excel
except I get an error that freezes everything up at the code listed above.

When I omit the "DisplayAlerts" code, everything works, but you have to
answer the pop-up questions to close "Employee Database".

How can I re-write this code?
 
As soon as you close that window (the workbook with the macro), then the macro
ends, too--since it just got closed.

I'd use this if the code is in the "employee database.xls" workbook's project:
thisworkbook.close savechanges:=false
or this
workbooks("employee database.xls").close savechanges:=false
if the code isn't in that workbook's project.
 
Actually, the code is in the other file ("UR"). So, the code doesn't close
when "Employee Database" closes???
 
Back
Top