| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close macro file
Hi,
I have built a macro in which it has done it thing. Now, it is complete, can I close the file that contains the macro too? Is that possible? MrRJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close macro file
try
application.quit "MrRJ" wrote: Hi, I have built a macro in which it has done it thing. Now, it is complete, can I close the file that contains the macro too? Is that possible? MrRJ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close macro file
ActiveWorkbook.Close
' closes the active workbook and lets the user decide if ' changes are to be saved or not On Feb 13, 2:26*pm, MrRJ wrote: Hi, I have built a macro in which it has done it thing. *Now, it is complete, can I close the file that contains the macro too? *Is that possible? MrRJ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close macro file
Jim: the problem is the saveas closes the oringal workbook and only nleaves
the saveas file opened. if yo want to go back to the original file you have to re-open the workbook. "Jim" wrote: ActiveWorkbook.Close ' closes the active workbook and lets the user decide if ' changes are to be saved or not On Feb 13, 2:26 pm, MrRJ wrote: Hi, I have built a macro in which it has done it thing. Now, it is complete, can I close the file that contains the macro too? Is that possible? MrRJ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close macro file
Thanks guys. I didn't want to close the whole application, just in case the
user has other files open. So, I created a simple line with the specific file name that the macro is being used. I am all good. "Joel" wrote: Jim: the problem is the saveas closes the oringal workbook and only nleaves the saveas file opened. if yo want to go back to the original file you have to re-open the workbook. "Jim" wrote: ActiveWorkbook.Close ' closes the active workbook and lets the user decide if ' changes are to be saved or not On Feb 13, 2:26 pm, MrRJ wrote: Hi, I have built a macro in which it has done it thing. Now, it is complete, can I close the file that contains the macro too? Is that possible? MrRJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close file macro | Excel Programming | |||
| Close file and run macro from newly opened file | Excel Programming | |||
| use a macro to close a file | Excel Programming | |||
| close file macro | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
