| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to code on Macro on saving and closing 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to code on Macro on saving and closing a file?
See response in .misc
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eric" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro help - closing without saving & empty clipboard | Excel Discussion (Misc queries) | |||
| Saving a CSV file from Excel with 0 in front of Zip code | Excel Discussion (Misc queries) | |||
| Macro Help for Saving a file | Excel Worksheet Functions | |||
| closing & saving | Excel Worksheet Functions | |||
| Is there any way to recover changes after closing w/o saving? | Excel Discussion (Misc queries) | |||
Linear Mode
