Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what do You say? :)
I use method OnTime and before close workbook I switch
schedule to False - I want bring to end some routine. When I work in Thisworkbook i've open another workbook in different windows, which i'd like remain it after Thisworkbook close. Code ActiveWorkbook.Close produce Window application (excel) isn't close and method OnTime still work though schedule is False ???!!! When i wrote: Application.Quit OnTime ... schedule:False work, but vba close all windows with remain workbook but i don't want it. How close only window with activeworkbook and remain another application(excel) with another workbook. Any help (code) will be appreciate. Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
what do You say? :)
Chip Pearson has some good information regarding OnTime:
http://www.cpearson.com/excel/ontime.htm -- Rob van Gelder - http://www.vangelder.co.nz/excel "Mark" wrote in message ... I use method OnTime and before close workbook I switch schedule to False - I want bring to end some routine. When I work in Thisworkbook i've open another workbook in different windows, which i'd like remain it after Thisworkbook close. Code ActiveWorkbook.Close produce Window application (excel) isn't close and method OnTime still work though schedule is False ???!!! When i wrote: Application.Quit OnTime ... schedule:False work, but vba close all windows with remain workbook but i don't want it. How close only window with activeworkbook and remain another application(excel) with another workbook. Any help (code) will be appreciate. Regards Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
what do You say? :)
Hi Rob,
I know method OnTime, i have problem with something else. (see my first post) Regards Mark -----Original Message----- Chip Pearson has some good information regarding OnTime: http://www.cpearson.com/excel/ontime.htm -- Rob van Gelder - http://www.vangelder.co.nz/excel "Mark" wrote in message ... I use method OnTime and before close workbook I switch schedule to False - I want bring to end some routine. When I work in Thisworkbook i've open another workbook in different windows, which i'd like remain it after Thisworkbook close. Code ActiveWorkbook.Close produce Window application (excel) isn't close and method OnTime still work though schedule is False ???!!! When i wrote: Application.Quit OnTime ... schedule:False work, but vba close all windows with remain workbook but i don't want it. How close only window with activeworkbook and remain another application(excel) with another workbook. Any help (code) will be appreciate. Regards Mark . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
what do You say? :)
MArk,
Have you tried Activewindow.Close or Windows(fname).Close -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark" wrote in message ... I use method OnTime and before close workbook I switch schedule to False - I want bring to end some routine. When I work in Thisworkbook i've open another workbook in different windows, which i'd like remain it after Thisworkbook close. Code ActiveWorkbook.Close produce Window application (excel) isn't close and method OnTime still work though schedule is False ???!!! When i wrote: Application.Quit OnTime ... schedule:False work, but vba close all windows with remain workbook but i don't want it. How close only window with activeworkbook and remain another application(excel) with another workbook. Any help (code) will be appreciate. Regards Mark |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
what do You say? :)
YES i tried but it doesn't show results.
Fairest solution would be use Application.Quit (then Excel's window close but if i've opened another excel they close too. Cordially Mark -----Original Message----- MArk, Have you tried Activewindow.Close or Windows(fname).Close -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark" wrote in message ... I use method OnTime and before close workbook I switch schedule to False - I want bring to end some routine. When I work in Thisworkbook i've open another workbook in different windows, which i'd like remain it after Thisworkbook close. Code ActiveWorkbook.Close produce Window application (excel) isn't close and method OnTime still work though schedule is False ???!!! When i wrote: Application.Quit OnTime ... schedule:False work, but vba close all windows with remain workbook but i don't want it. How close only window with activeworkbook and remain another application(excel) with another workbook. Any help (code) will be appreciate. Regards Mark . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|