VBA not closing *.xlsx file

[Cummins]

My code opens, creates and then closes a file when the information has been collected. The following line has always worked before. The only change is that the default file type is now *.xlsx.

Workbooks(TempBookName).Close SaveChanges:=False

Is the command different in 2010?

 

[Domenic]

It should close your workbook, without saving it. I'm assuming that TempBookName is a variable holding the name of the workbook that you'd like close, correct? What value has it been assigned? Also, when you say that it doesn't work, what happens exactly?

 

[Cummins]

Yes, TempBookName is a variable. It literally creates a temporary file....Book31.xls (or Book31.xlsx), Book32.xls (or Book32.xlsx)....
Every time the vba program reaches the line to close the file, the pop up screen opens asking if I want to save the file....
I tried something and here is the issue. This only started when I saved the VBA program as *.xlsm instead of *.xls. Obviously, something changed....

 

[Domenic]

See if the following helps...

http://www.rondebruin.nl/saveas.htm