| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to code the Macro to save and close a file?
Workbooks.Open Filename:="C:\Files\1.xls", _
UpdateLinks:=3 ActiveWorkbook.Save ActiveWindow.Close The command "ActiveWindow" cannot be performed, does anyone have any suggestions on how change the code for specific file under specific directory, such as Save "C:\Files\1.xls" to replace the code ActiveWorkbook.Save Close "C:\Files\1.xls" to replace the code ActiveWorkbook.Close Thank for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to save & close all opened files | Excel Discussion (Misc queries) | |||
| VBA Code to kick off macro when workbook command to close is initi | Excel Discussion (Misc queries) | |||
| Macro VBA code to name Save-As file | Excel Worksheet Functions | |||
| File close excel does not ask me to save changes | Excel Discussion (Misc queries) | |||
| I can't save a file unless I close all excel instances or it's th. | Excel Discussion (Misc queries) | |||
Threaded Mode
