Avioding "Version Update" Dialogue Box
 

I have the frequent need to open, copy data from, and close nearly a hundred shared prior version (Excel 2000) workbooks. What VBA code can I insert in the Excel 2003 macro to preserve the original prior version without the need to click "no" in the "update to new version" prompt " for every workbook? "ActiveWindow.Close SaveChanges:=False" rejects changes, but saves in the new Excel version. I do not want to save in the larger dual version format either. Thank you

Avioding "Version Update" Dialogue Box
 

ActiveWorkbook.Close SaveChanges:=False

would not save in the newer format or offer the prompt.

--
Regards,
Tom Ogilvy

"Sat" wrote in message
...
I have the frequent need to open, copy data from, and close nearly a
hundred shared prior version (Excel 2000) workbooks. What VBA code can I
insert in the Excel 2003 macro to preserve the original prior version
without the need to click "no" in the "update to new version" prompt " for
every workbook? "ActiveWindow.Close SaveChanges:=False" rejects changes,
but saves in the new Excel version. I do not want to save in the larger
dual version format either. Thank you

Avioding "Version Update" Dialogue Box
 

Thank you.


"Tom Ogilvy" wrote:

ActiveWorkbook.Close SaveChanges:=False

would not save in the newer format or offer the prompt.

--
Regards,
Tom Ogilvy

"Sat" wrote in message
...
I have the frequent need to open, copy data from, and close nearly a
hundred shared prior version (Excel 2000) workbooks. What VBA code can I
insert in the Excel 2003 macro to preserve the original prior version
without the need to click "no" in the "update to new version" prompt " for
every workbook? "ActiveWindow.Close SaveChanges:=False" rejects changes,
but saves in the new Excel version. I do not want to save in the larger
dual version format either. Thank you