Avioding "Version Update" Dialogue Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
vba code does not run 3
Iterative consolidation macro can't complete - memory overload? 5
Excel 95 equivalent of modern events? 6
Large Amount of Info on Clipboard 2
All Workbook Saved except This Workbook 3
forcing specific sheet opening upon launch of .xlsx file 4
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Back
Top