View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
 
Posts: 273
Default 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.