Close Word doc from Extra

JeaShe · Apr 6, 2005

The macro I run opens a Word doc and after going through a routine, it prints the doc. Then I want to close the doc (not Word, just that doc) without saving the changes. The VBA code is:

Documents.Close SaveChanges:=wdDoNotSaveChanges

With minor differences mine would read:
objDoc.Close SaveChanges:=wdDoNotSaveChanges

However Extra considers everything after Close a new variable. I know that objDoc.Close works but it leaves the box to save the doc up. Any ideas how I can get Extra to recognize the command not to save changes?

calculus · Apr 6, 2005

Usually these text constants actually have an integer value (flag). If you hover over the text in VBA it will tell you the integer. Plug that into EB and it will likely work.

Something like this:
objdoc.close 3

calculus

JeaShe · Apr 6, 2005

good idea... I'll try it

JeaShe · Apr 14, 2005

It works beautifully in Word, but how do I do it in Excel?? Can't get the same thing to work there! So frustrated!

calculus · Apr 18, 2005

oBook.close false" works for me.

calculus

JeaShe · Apr 18, 2005

Woo-hoo! It works! Thanks Calculus

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Close Word doc from Extra

JeaShe

Programmer

calculus

Programmer

JeaShe

Programmer

JeaShe

Programmer

calculus

Programmer

JeaShe

Programmer

Similar threads

Part and Inventory Search

Sponsor