Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VB in Excel to close open Word Document
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VB in Excel to close open Word Document
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel trying to open word document | Excel Discussion (Misc queries) | |||
Open A Word Document from Excel | Excel Programming | |||
what happens if I open an excel document in word? | Excel Discussion (Misc queries) | |||
open up a word document in excel | Excel Programming | |||
Open a word document in excel | Excel Programming |