View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Use VB in Excel to close open Word Document

have it print in the foreground.

--
Regards,
Tom Ogilvy

"Gary" wrote in message
...
Hi just to update.
I have worked out what the debugger error is on the .Quit command.
I am trying to close Word whilst it is still printing the document. Any
ideas of what I need to add in to allow Word to finish printing before
closing.
Thanks
Gary

"Gary" wrote:

Hi, new to all this.
Using Visual Basic I have managed to get Excel to open up a word

document,
add some data to it from an Excel workbook, save and print it off, I am

just
looking for a way of closing the document back down again using

VBscript. I
have tried using .Close to no nocicable results and the help wizard

suggests
.appWd.Quit which the debugger does not like. Any ideas? Thanks in

advance.