Avioding "Version Update" Dialogue Box

S

Sat

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
 
T

Tom Ogilvy

ActiveWorkbook.Close SaveChanges:=False

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

--
Regards,
Tom Ogilvy

Sat said:
I have the frequent need to open, copy data from, and close nearly a
Click to expand...
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
 
S

Sat

Thank you.


Tom Ogilvy said:
ActiveWorkbook.Close SaveChanges:=False

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

--
Regards,
Tom Ogilvy


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
Click to expand...
 
Top