Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to close a excel file using Macro coding?
Referring to the post in Worksheet Function
Once I open the file 1.xls, and try to run following Macro. There is an error message "Array exceeds the range" [Translation from Chinese] Sub Eric() Workbooks("E:\1.xls").Close End Sub Does anyone have any suggestions what wrong is the above code? and how to fix it? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code the Macro to save and close a file? | Excel Discussion (Misc queries) | |||
Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
recrding macro,copy data thn close file, get messge abut clpbord | Excel Discussion (Misc queries) | |||
Macro to close excel | Excel Discussion (Misc queries) | |||
macro to close excel | Excel Discussion (Misc queries) |