View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark[_17_] Mark[_17_] is offline
external usenet poster
 
Posts: 95
Default 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




.