View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sat Sat is offline
external usenet poster
 
Posts: 2
Default 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