Re: Close word window usering VBA

Hello Kezza.

Here's an idea which you can use often:

1) Open a few documents
2) Start the Macro Recorder
3) Close a single document (leave the others open)
4) Stop the Macro Recorder
5) Press "F11" to go into the IDE and learn from that code
6) Type a few things of this code in google, and find out how others use
this code. They may have smarter or better ideas which handle odds and ends.

Basically this is your code:

Windows("Doc2.doc").Activate
ActiveDocument.Close

So your combinations were close, but you haven't tried this one yet :)

~Val

"Kezza" <Kezza@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:91A1701F-0E3D-46F6-A9E4-5E496D04AFDF@xxxxxxxxxxxxxxxx
Hi There
I am trying to work out how to close a single word window without closing
any other word windows that might be open.

The issue is that if this is the only document left open.. it closes the
document but still leaves the word window open.

I have tried the following
Me.Application.ActiveWindow.Close
Windows("conquest report.doc").Parent.Close
SaveChanges:=wdDoNotSaveChanges
ActiveDocument.Close wdDoNotSaveChanges
Windows("A.doc").Application.Quit

Non of this code gives me the solution I am looking for.

I would really appreciate some assistance.

Thanks


.

Relevant Pages

  • Re: Close word window usering VBA
    ... Dim objWdApp As Word.Application ... Start the Macro Recorder ... I am trying to work out how to close a single word window without closing ...
    (microsoft.public.office.developer.vba)
  • Re: Close word window usering VBA
    ... Start the Macro Recorder ... They may have smarter or better ideas which handle odds and ends. ... I am trying to work out how to close a single word window without closing ...
    (microsoft.public.office.developer.vba)
Loading