Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
getting rid of the "confirm delete" dialogue box when deleting a s | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
cancel the "Getting Started" Dialogue Box when I open XL/Word | Setting up and Configuration of Excel | |||
"Save In" dialog (dialogue) issue | Excel Discussion (Misc queries) | |||
VB coding for showing "find" dialogue box? | Excel Programming |